Error ORA-00904 on Export

pts.
Tags:
Oracle
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Zimmerkidz
    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.
    0 pointsBadges:
    report
  • Cwilsonnz
    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.
    0 pointsBadges:
    report
  • Zimmerkidz
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/error-ora-00904-on-export/ (0) Comments Read [...]
    0 pointsBadges:
    report
  • Brijesh
    9,870 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following