OraFAQ Forum: Server Utilities » export

Home » RDBMS Server » Server Utilities » export - ORA-00904

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export - ORA-00904 [message #69351]

Fri, 14 December 2001 01:58

Lena Pilloni
Messages: 5
Registered: October 2001

Junior Member

i am unable to do an 'export' with parameter 'full=y'; this operation has been unsuccesfull as you can see from the error (ORA-00904: invalid column name).
i managed to do the export only for my user, so i think this means that the error affects only the system tablea.

Could you help me?
i look forward to receiving your answer.
bye

----------------------------------------------------------------------

Report message to a moderator

Re: export - ORA-00904 [message #69356 is a reply to message #69351]

Fri, 14 December 2001 07:37

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

do you have EXP_FULL_DATABASE role?

----------------------------------------------------------------------

Report message to a moderator

Re: export - ORA-00904 [message #69365 is a reply to message #69351]

Sat, 15 December 2001 11:07

E.V.
Messages: 1
Registered: December 2001

Junior Member

I have encountered this myself also recently, exporting by OWNER. Using one _earlier_ version of the EXP command tool has solved this. (e.g 7.3.3. instead of 7.3.4)
BTW:Besides the ORA-00904 error, al lot of other errors did also occur. These have gone away also.

HTH, succes!
E.V.

----------------------------------------------------------------------

Report message to a moderator

Re: export - ORA-00904 [message #69370 is a reply to message #69351]

Mon, 17 December 2001 00:27

Lena Pilloni
Messages: 5
Registered: October 2001

Junior Member

i did 'exort' using 'SYSTEM' as owner, i think that this owner has DBA roles.
Where can i look for 'exp_full_database' role?

i look forward to your reply.
bye

----------------------------------------------------------------------

Report message to a moderator

Re: export - ORA-00904 [message #69534 is a reply to message #69356]

Mon, 28 January 2002 02:10

wesqdw
Messages: 1
Registered: January 2002

Junior Member

How is this ????

Report message to a moderator

Previous Topic:	How to rename a tablespace using import
Next Topic:	PIVOTING IN ORACLE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 09:06:51 CDT 2024