-
folks
this is the error im getting when im exporting from one of our database.
''. . exporting table UPDATE_MGR 13 rows exported
. . exporting table USER_RESOURCES 0 rows exported
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully"
due to this im not able to import all the objects in databse.
this database from which ihave exported is working fine ,but this error of invalid column is what im concerned as there is nothing like that
its very urgent
folks
pls
-
what version of oracle are you running?
d.
-
hi im sorry..im running 8.1.5 on solaris 2.6..
Now i did run catexp.sql after logging as internal still thats the problem thx
sat
-
from metalink i have found (if running catexp doesn't work)
Try after running $OH/javavm/install/initdbj.sql as internal (UNIX)
read it first; i don't know what that script would do--i have not personally encountered
d.
[Edited by DBAtrix on 02-13-2001 at 05:13 PM]
-
Hi DBATrix.,
the solution u gave solved my problem.Now im taking exports
easily and importing..Thanks a lot buddy
sat