OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » export error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export error [message #225588]

Tue, 20 March 2007 07:45

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

Mahesh Rajendran
Messages: 10707
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

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

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:42:43 CDT 2024