Tip 8: Invoking oracle tools with sysdba role

10/25/2006; 8:10 AM

Setting a sysdba role in command line parameters when invoking oracle tools can be done like this. For example to set the sysdba role to a user when importing an exported file:-

imp userid='"user1/password@machine as sysdba"' fromuser=user1 touser=user1 file=test.dmp

It's a good idea to specify the fromuser and touser parameters because otherwise they objects get imported into the sys user.

Logon

Fill out the form below to logon to this site, or sign up below.

Username (email address):
Password:
I forgot my password; please send me a new one.
 

Signup

Fill out the form below to join as a member of this site.

Screen name:
Email address:
Password:
Repeat password:
Homepage (optional)