Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10g stats
chris b wrote:
> We are currently migrating to 10.2.0.3 enterprise ( from 8i ) by
> 1) datpumping schema
> 2) Running histogram scripts
> eg DBMS_STATS.GATHER_TABLE_STATS ('LIVCACHE','MI_BATCH',METHOD_OPT=>'
> FOR COLUMNS BATCH_NO SIZE 75');
>
> 3) Gathering stats on all by using method_opt FOR ALL COLUMNS SIZE
> REPEAT
>
> When I check for histograms afterwards I find that step 3 has created
> new histograms ...whereas I thought this option would only build a
> histogram if one already existed / Can anyone advise if my expectation
> of the result is flawed and if so why?
>
Care to explain how you use datapump in an 8i database?
From
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#i1007148:
"Data Pump Export only works with Oracle Database 10g release 1 (10.1)
or later"
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Nov 12 2007 - 12:59:56 CST