Re: cannot export

What is the version of the export utility you are using? Is it 8.1.7 on the same WNT 4.0 machine and from the same ORACLE_HOME? Mayby you need to re-run rbms/admin/catexp.sql script FROM THE SAME ORACLE_HOME as where the database runs because someting has gone wrong when the database was created.

Or are you making a client/server export from a different host? If your export utility is from another version then it depends how to solve it.
If it's V7 run catexp7 on the server machine FROM THE SAME ORACLE_HOME as where the database runs. This creates V7 export/import views that can co-exist witht the V8 views.
If it's V8.0.x of V8.1.5 of V8.1.6 I don't know if you can solve it. Check Metalink for it.

zeb <thierry.constant1_at_free.fr> schreef in berichtnieuws 3d159c58$0$10483$626a54ce_at_news.free.fr...
| Hi,
|
| I try to export a database ( 8.1.7 , WNT 4.0 SP6 )
| with any options (full=y or owner=user), it failed
| when it try to export the synomyms
| whith:
|
| ORA-00904 invalid column name
| How can I fix this ?
|
| Thanks for your help ...
|
|
|
|
Received on Sun Jun 23 2002 - 05:31:50 CDT