Correct - Datapump (impdp/expdp) is a 10G New Feature - not downwards
compatible
Frank van Bortel wrote:
> 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"
Received on Mon Nov 12 2007 - 13:05:19 CST
