topic Re: oracle error 904 while attempting to do full db export in Operating System - HP-UX

oracle error 904 while attempting to do full db export

Danny Pogi — Mon, 18 Nov 2002 02:16:41 GMT

hi guys,

im using oracle version 8.0.4 over hpux 10.20...i have created an oracle user x with dba priviledges...upon execution of the exp command
" $ exp x/password full=y file=file.dmp log=exp.log "

i encountered the error listed below:

...exporting table DEF$_AQCALL
exp-00008: ora error 904 enc.

ORA-00904: invalid column name Bus error (coredump)

What could possibly wrong with my db? I want to make a full database export.

Thanks in advance.

regards,
danny

Re: oracle error 904 while attempting to do full db export

T G Manikandan — Mon, 18 Nov 2002 05:41:29 GMT

I am not sure whether you had installed some patches with the existing Oracle version.
Re-run your catexp.sql as internal user.

$ORACLE_SID=<>
$export ORACLE_SID

$svrmgrl
svrmgr>connect internal
svrmgr>@$ORACLE_HOME/rdbms/admin/catexp.sql

Revert after running the same

Re: oracle error 904 while attempting to do full db export

John Palmer — Mon, 18 Nov 2002 07:02:36 GMT

Hi,

I've found an entry on metalink that states that you should drop all the Replication Queue tables before doing a full export (after backing everything up).

I recommend that you raise a tar woth Oracle.

Regards,
John

Re: oracle error 904 while attempting to do full db export

Andreas D. Skjervold — Mon, 18 Nov 2002 08:58:39 GMT

Hi

Try reinstalling the export views by running catexp.sql
SVRMGR> connect internal
SVRMGR> @?/rdbms/admin/catexp.sql

Andreas

Re: oracle error 904 while attempting to do full db export

Andreas D. Skjervold — Mon, 18 Nov 2002 09:02:53 GMT

Ooops!
Didn't see that our friend Manikandan had posted the same answer...
Maybe a good idea to read the thread before posting....

Andreas