Home » RDBMS Server » Server Administration » 9i - Exporting?
9i - Exporting? [message #62045] Mon, 21 June 2004 22:36 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

 

I am running Oracle 9i on Sun Solaris platform.

 

I want to perform an export. At the command line I do something like:

 

exp 'sys/sys' parfile=export.par

 

I always get the message, must login as sysdba. So, I try:

 

exp 'sys/sys as sysdba' parfile=export.par

 

However, this does not work either ....

 

How can I perform an EXPORT using 'sys' username and sysdba privilege from the command line?

 

Thanks ... IA

Report message to a moderator

Re: 9i - Exporting? [message #62047 is a reply to message #62045] Tue, 22 June 2004 00:55 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
User user SYSTEM. In Oracle9i user SYS can connect only as sysdba.

Report message to a moderator

Re: 9i - Exporting? [message #62092 is a reply to message #62045] Thu, 24 June 2004 06:27 Go to previous message
Ross Clarke
Messages: 1
Registered: June 2004
Junior Member
try

exp userid="'sys/password as sysdba'"

Report message to a moderator

Previous Topic: RE:slow performance
Next Topic: SPACE LEAK
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 04:27:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.