General
cancel
Showing results for 
Search instead for 
Did you mean: 

Help!! Cannot do a FULL export of ORACLE database

SOLVED
Go to solution
Enrico Venturi
Super Advisor

Help!! Cannot do a FULL export of ORACLE database

Hello colleagues,
I try to run "/opt/oracle/bin/exp" utility
with the proper password etc.
When I ask FULL=Y the error message EXP-00023 os issued;
the strange fact is that I run the command as ORACLE administrator!!!!
Where's the problem?

many thanks
Enrico
6 REPLIES
Ian Lochray
Respected Contributor

Re: Help!! Cannot do a FULL export of ORACLE database

When you say the "Oracle administrator" do you mean the Oracle user "system"?
Enrico Venturi
Super Advisor

Re: Help!! Cannot do a FULL export of ORACLE database

I mean the user "oracle" which belongs to the group "DBA" ...
Where can I look to know which is the proper user oracle administrator?
Graham Cameron_1
Honored Contributor

Re: Help!! Cannot do a FULL export of ORACLE database

Enrico

Try this:

SQL> ALTER USER xxx DEFAULT ROLE exp_full_database;

-- Graham
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.
Enrico Venturi
Super Advisor

Re: Help!! Cannot do a FULL export of ORACLE database

Graham,
which is the right user to run the command you suggest?
Ian Lochray
Respected Contributor
Solution

Re: Help!! Cannot do a FULL export of ORACLE database

If you want to do a full database export i.e. export all data for all the Oracle users in the SID, then you should log on as the user oracle like you did and in your exp command specify an Oracle user with the correct priviliges i.e. the "system" user. Your command should look like ...

exp system/systempassword file=outputfile full=y
Graham Cameron_1
Honored Contributor

Re: Help!! Cannot do a FULL export of ORACLE database

#
sqlplus /nolog
SQL> connect sys/ as sysdba
SQL> SQL> ALTER USER xxx DEFAULT ROLE exp_full_database;
SQL> exit
exp etc
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.