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: Sun May 04 14:32:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.