topic Re: Help!! Cannot do a FULL export of ORACLE database in Operating System - HP-UX

Help!! Cannot do a FULL export of ORACLE database

Enrico Venturi — Thu, 06 Nov 2003 06:14:57 GMT

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

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

Ian Lochray — Thu, 06 Nov 2003 06:20:51 GMT

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

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

Enrico Venturi — Thu, 06 Nov 2003 06:23:12 GMT

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

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

Graham Cameron_1 — Thu, 06 Nov 2003 06:24:06 GMT

Enrico

Try this:

SQL> ALTER USER xxx DEFAULT ROLE exp_full_database;

-- Graham

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

Enrico Venturi — Thu, 06 Nov 2003 06:25:15 GMT

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

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

Ian Lochray — Thu, 06 Nov 2003 06:28:33 GMT

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

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

Graham Cameron_1 — Thu, 06 Nov 2003 06:29:12 GMT

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