topic Re: Export terminated successfully with warnings in Operating System - HP-UX

Export terminated successfully with warnings

Prabhu_7 — Wed, 20 Aug 2003 22:32:16 GMT

I'm trying to export data of a table.
I get the following warning !!!!
How to solve this ?

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table TBAW_PCTR_WAIVED 4967133 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
Export terminated successfully with warnings.

Why am i getting invalid column name when exporting ? i'm not doing any import.
I'm just exporting to a dump file.

I read somewhere about catexp.sql
Can anyone throw light about this file.
Where can i find this ? how to run this ?
Please tell me in simple steps.

Thanks a lot.

Re: Export terminated successfully with warnings

twang — Wed, 20 Aug 2003 23:57:26 GMT

These errors occur when the 8.1.7 import and export utilities are used against an Oracle 8.1.6 database. If your repository is installed on an Oracle 8.1.6 database, do not install the import and export utilities from the Designer CD, instead install from oracle 8.1.6 CD.

Re: Export terminated successfully with warnings

Steven E. Protter — Thu, 21 Aug 2003 00:18:01 GMT

Translation: Don't trust the data unless you've verified the data.

I'd check my process as recommended and do it again.

SEP

Re: Export terminated successfully with warnings

Brian Crabtree — Thu, 21 Aug 2003 00:37:55 GMT

The catexp.sql file is the script that loads/reloads the export views in the database. These views tend to change between versions and patchsets of Oracle, and need to be run whenever you upgrade your version. It also means that different versions (patchsets included) of the exp and imp binaries will not always run correctly on older or newer versions of Oracle.

You will find this file in $ORACLE_HOME/rdbms/admin. It can be run from sqlplus or svrmgrl, but should always be run as internal or sysdba.

Thanks,

Brian

Re: Export terminated successfully with warnings

Indira Aramandla — Thu, 21 Aug 2003 05:14:21 GMT

Hi Praphu,

This problem arises if :-
1. The database that you took export and the exp utility are not of the same version. (For example like Twang said, ???when the 8.1.7 export utility is used against an Oracle 8.1.6 database???.
2. If you upgraded / migrated your database

The problem will be resolved by running catexp.sql found in $ORACLE_HOME/rdbms/admin/ directory as user sys. Then you try to export.

IA

Re: Export terminated successfully with warnings

T G Manikandan — Thu, 21 Aug 2003 05:19:51 GMT

If you are exporting from the client check for the imp and exp versions from the client installation against to the server database version.

If you are exporting from the server,re-run catexp.sql which should resolve the problem

Thanks

Re: Export terminated successfully with warnings

twang — Thu, 21 Aug 2003 05:25:56 GMT

If you ran into this problem after upgrading RDBMS from 8.1.7.0 to 8.1.7.3. To resolve this, you can replace the $ORACLE_HOME/bin/exp with the old one (from the version 8.1.7.0).