Error ORA-00904 on Export
I am running an export command for backup purposes and receive the following error:
Connected to: Oracle8i Release 8.1.5.0.5 - Production (5 user, NetWare Bundle)
PL/SQL Release 8.1.5.0.5 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
.
.
.
. exporting referential integrity constraints
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
How do I find out what column name is invalid and correct it?
I have looked through synonyms and views which is the next object to be exported, and I do not see anything that is wrong.
Software/Hardware used:
Software/Hardware used:
ASKED:
September 23, 2005 12:36 PM
UPDATED:
September 25, 2005 9:12 PM
RELATED QUESTIONS
- Oracle 9i export unsuccessful since patch update.
- Trying to solve ORA-00980: synonym translation is no longer valid
- Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g :
- Updating Microsoft SQL Server tables from Oracle generates error
- Copy a SQL Binary Large Object (BLOB) from one database to another
Answer Wiki:
This is pure speculation, have you changed your character set? Has this export ever worked? When did you last change the schema (and what did you/they alter)?
To see all answers submitted to the Answer Wiki: View Answer History.
The character set has never been changed. I’m not sure that this export has ever worked as I am setting up an alternate backup to complement our total system backup to tape. Any changes that have been made have been to one of the user database and has not involved any changes to the basic system setup.
What version and patch level is the database? If the database was created after a patch was installed,
example, 9.2.0.1 upgraded to 9.2.0.4 and then database created
you may need to process the 9.2.0.4 patch ‘catpatch.sql’ to the database for the export to work.