RE: Copying statistics

Take a look at the "Transferring Statistics" section of the new DBMS_STATS package. It's in the "Supplied Packages Reference" manual.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Khedr, Waleed
Sent: Wednesday, June 07, 2000 2:45 PM
To: Multiple recipients of list ORACLE-L Subject: Copying statistics

Is there a way to copy the optimizer statistics from one table partition to a similar one?

Oracle 8.1.5 & 8.1.6

Thanks

Waleed

--
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).