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: 195
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
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: 64102
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
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: 195
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
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: 64102
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
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: 195
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
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: 64102
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
Previous Topic: export error
Next Topic: Importing a single table
Goto Forum:
  


Current Time: Fri Dec 02 14:03:05 CST 2016

Total time taken to generate the page: 0.13029 seconds