Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Export terminated successfully with warnings

Prabhu_7
Frequent Advisor

Export terminated successfully with warnings

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.
6 REPLIES
twang
Honored Contributor

Re: Export terminated successfully with warnings

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.
Steven E. Protter
Exalted Contributor

Re: Export terminated successfully with warnings

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

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

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Brian Crabtree
Honored Contributor

Re: Export terminated successfully with warnings

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
Indira Aramandla
Honored Contributor

Re: Export terminated successfully with warnings

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
Never give up, Keep Trying
T G Manikandan
Honored Contributor

Re: Export terminated successfully with warnings

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
twang
Honored Contributor

Re: Export terminated successfully with warnings

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).