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
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: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you are specifying both OWNER/USER and TABLE level export.
Remove one of them.
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
Re: export error [message #225600 is a reply to message #225594] Tue, 20 March 2007 08:01 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Only that, i would not use sys for any routine jobs like export/import.
Previous Topic: Import restoration to the same table
Next Topic: export DBA privilege
Goto Forum:
  


Current Time: Mon Dec 05 08:37:50 CST 2016

Total time taken to generate the page: 0.09443 seconds