Re: portable statistics

2001-12-03 Thread Ruth Gramolini
The database in question is cloned so I don't have to worry. Thanks! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 30, 2001 12:16 PM If you genuinely clone a database ie copy the datafiles, then the stats will also be

portable statistics

2001-11-30 Thread Ruth Gramolini
Good morning again, I know that in 8i you can move statistics where you clone a database. Is it possible in 8.0.6.3? Thanks! Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: portable statistics

2001-11-30 Thread Connor McDonald
If you genuinely clone a database ie copy the datafiles, then the stats will also be transferred. Other than that, you would need dbms_stats which comes only at 8.1+. You could always hack the internal sys tables - probably not the wisest option to persue :-) Cheers Connor --- Ruth Gramolini