Home » RDBMS Server » Server Utilities » export DBA privilege
export DBA privilege [message #225611] Tue, 20 March 2007 09:11 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I am trying to do a full database export and when i give the username it say dont have DBA privilge(EXP-00023: must be a DBA)
but when i try giving username sys it starts the export but stops within few seconds giving error EXP-00008: ORACLE error 904 encountered.
Is it good idea to do an exp using user SYS,as at some places its mentioned one should not user SYS

Report message to a moderator

Re: export DBA privilege [message #225612 is a reply to message #225611] Tue, 20 March 2007 09:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you try to export with a previous version exp or the current version?
Did you previously run $ORACLE_HOME/rdbms/admin/catexp.sql?

Regards
Michel

Report message to a moderator

Re: export DBA privilege [message #225619 is a reply to message #225611] Tue, 20 March 2007 09:46 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
I am taking an export backup from standby database which is readonly and running catexp cannot write to system.dbf

Report message to a moderator

Re: export DBA privilege [message #225624 is a reply to message #225619] Tue, 20 March 2007 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It should be done on the primary base prior to the instantiation.
It can be done now if you put the standby in recovery mode.

Regards
Michel

Report message to a moderator

Re: export DBA privilege [message #225629 is a reply to message #225624] Tue, 20 March 2007 11:01 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
how does it matter as catexp needs to write on system.dbf and how can putting standby in recovery mode help this

Report message to a moderator

Re: export DBA privilege [message #225632 is a reply to message #225629] Tue, 20 March 2007 11:31 Go to previous message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to shutdown and restart the standby database but the whole process depends on your Oracle version, if you use DataGuard or not to manage your standby database, the way archived log are propagated to standby server and so on.
I advice you to read documentation on standby database before doing any thing.

Regards
Michel

Report message to a moderator

Previous Topic: export error
Next Topic: Importing a single table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 20:29:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.