Home » RDBMS Server » Server Utilities » EXP-00026: conflicting modes specified
EXP-00026: conflicting modes specified [message #19224] Tue, 05 March 2002 22:06 Go to next message
krahuman
Messages: 18
Registered: January 2002
Junior Member
Hello ORA8is !

why i can't get a backup from the following ?

host('exp scott/tiger@oracle
file=c:backupcustomer.dmp
log =c:backupcustomer.log
owner=scott grants=y rows=y tables = customer');

when i execute this in d2k forms 5.0 IN THE ora.server only a zero bytes customer.dmp
is created.
the follwing is the log genarated.

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

if i want to run this in a cliect what are the utilities i have to install to the client?
krahuman
Re: EXP-00026: conflicting modes specified [message #19228 is a reply to message #19224] Wed, 06 March 2002 04:24 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
the error is EXP-00026, which says
" only one parameter (TABLES, OWNER, or FULL) can be specified"

u have specifed tables as well as owner.

it seems u r only want to export customer table , os take out "owner=scott", this is not required as u r connecting as "scott" user

so ur final command should be

host('exp scott/tiger@oracle
file=c:backupcustomer.dmp
log =c:backupcustomer.log
grants=y rows=y tables = customer');

i think this will solve ur problem
Re: EXP-00026: conflicting modes specified [message #453746 is a reply to message #19228] Fri, 30 April 2010 09:48 Go to previous messageGo to next message
bgermain1985
Messages: 1
Registered: April 2010
Junior Member
Yes, I faced a similiar issue today, where providing an export request passing owner along with the login info caused complications.

If the owner attribute is removed, the exception 'invalid modes' is no longer returned.

Thanks again!
Re: EXP-00026: conflicting modes specified [message #528317 is a reply to message #19228] Mon, 24 October 2011 04:51 Go to previous messageGo to next message
OracGPS
Messages: 17
Registered: April 2011
Junior Member

exp system/oracle file=a.dmp owner=scott tables=emp

i don't understand why "owner" vs "tables" have conflicte.

because i use sytem user. so why have conflicte.
Re: EXP-00026: conflicting modes specified [message #528321 is a reply to message #528317] Mon, 24 October 2011 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because Oracle programs it as it. You have nothing to understand just to admit that you can use only one of full/owner/tables options.

Your command can (and must) be written as:
exp system/oracle file=a.dmp tables=scott.emp

Regards
Michel
Re: EXP-00026: conflicting modes specified [message #528436 is a reply to message #528321] Mon, 24 October 2011 20:13 Go to previous message
OracGPS
Messages: 17
Registered: April 2011
Junior Member

OK, I know. thanks.
Previous Topic: importing full database with different database name and sid
Next Topic: EXP/IMP Fail
Goto Forum:
  


Current Time: Tue Feb 25 04:46:22 CST 2020