Home » RDBMS Server » Server Utilities » export error
export error [message #225588] Tue, 20 March 2007 07:45 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
exp sys/password file=mytable.dmp log=mytable.log \
ROWS=N OWNER=PRODADMIN TABLES=prod_list_accpp

EXP-00026: conflicting modes specified

any idea why this error

Report message to a moderator

Re: export error [message #225592 is a reply to message #225588] Tue, 20 March 2007 07:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you are specifying both OWNER/USER and TABLE level export.
Remove one of them.

Report message to a moderator

Re: export error [message #225594 is a reply to message #225588] Tue, 20 March 2007 07:56 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Yeah now i got it.i change the script as

exp sys/password file=mytable.dmp log=mytable.log \
ROWS=N TABLES=PRODADMIN.prod_list_accpp

and it worked.

Thnks

Report message to a moderator

Re: export error [message #225600 is a reply to message #225594] Tue, 20 March 2007 08:01 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Only that, i would not use sys for any routine jobs like export/import.

Report message to a moderator

Previous Topic: Import restoration to the same table
Next Topic: export DBA privilege
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 20:26:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.