Export

[charlton]

Hi DBA Guru's

Problem goes something like this:

Exporting Oracle 9.2.1.0 database from a 8.1.6.0 client.


Try and do a export and I get the following error.
Invalid field name.
ORA-00904: invalid column name
ORA-06512: at "SYS.DBMS_STATS", line 4432
ORA-06512: at "SYS.DBMS_STATS", line 4563
ORA-06512:
General SQL error.
at "SYS.DBMS_STATS", line 4714
ORA-06512: at "SYS.DBMS_STATS", line 4699
ORA-06512: at line 1
-- saved at 2006/05/16 13:54:15

BEGIN DBMS_STATS.GATHER_DATABASE_STATS( OPTIONS=>'GATHER',ESTIMATE_PERCENT=>10, CASCADE => TRUE ); END;


Checked for invalid objects to see if DBMS_STATS isn't invalid, but no invalid objects on the DB. Gather stats also works 100%. So why would it complain about this?

Anyone know how to resolve this problem.

Thanks in advance,
Charlton

[ebrian]

What does your export command look like?

Try to set STATISTICS = NONE and do the export again.

[ixion]

Try using a 9.2.1.0 client.