Operating System - HP-UX
1748263 Members
3787 Online
108760 Solutions
New Discussion юеВ

oracle error 904 while attempting to do full db export

 
Danny Pogi
Advisor

oracle error 904 while attempting to do full db export

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
4 REPLIES 4
T G Manikandan
Honored Contributor

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

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
John Palmer
Honored Contributor

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

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
Andreas D. Skjervold
Honored Contributor

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

Hi

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

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Andreas D. Skjervold
Honored Contributor

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

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

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!