Help!! Cannot do a FULL export of ORACLE database

[Enrico Venturi]

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

[Ian Lochray]

When you say the "Oracle administrator" do you mean the Oracle user "system"?

[Enrico Venturi]

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]

Enrico

Try this:

SQL> ALTER USER xxx DEFAULT ROLE exp_full_database;

-- Graham

[Enrico Venturi]

Graham,
which is the right user to run the command you suggest?

[Ian Lochray · Accepted solution]

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]

#
sqlplus /nolog
SQL> connect sys/ as sysdba
SQL> SQL> ALTER USER xxx DEFAULT ROLE exp_full_database;
SQL> exit
exp etc