EXP-00026: conflicting modes specified

Answers were Sorted based on User's Feedback



EXP-00026: conflicting modes specified..

Answer / roopa

Got the solution.

Instead of the command
"exp user/pwd file=exp.dmp owner=E1 tables=(A1, A2, A3)"

use

"exp user/pwd file=exp.cmp tables=(E1.A1, E1.A2, E1.A3)"

Is This Answer Correct ?    45 Yes 5 No

EXP-00026: conflicting modes specified..

Answer / thaejas

I have tried in Oracle 10.2.0.1.0 with the export command
by using both owner and tables in the parameter list.

As the owner is same as the login user id used and the
tables belong to the login user, owner should be omitted
when mentioning the tables list.

Is This Answer Correct ?    19 Yes 1 No

EXP-00026: conflicting modes specified..

Answer / roopa

But I need to export the data of another user using my
login id. And also I need to exclude few tables. In that
case I have to use both owner and tables parameter.

How this problem can be solved?

Is This Answer Correct ?    6 Yes 2 No

EXP-00026: conflicting modes specified..

Answer / guest

Cause: Conflicting export modes were specified.

Action: Specify only one parameter and retry.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 9 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00309: No SQL string allowed as part of string field specification

1 Answers  


RMAN-08550: autobackup search outside recovery area not attempted because DBID was not set

1 Answers  


TNS-12230: TNS:Severe Network error occurred in making this connection

1 Answers  


NID-00398: Changing database ID from number to number

1 Answers  


IMG-00806: invalid input image

1 Answers  






ORA-30038: Cannot perform parallel insert on non-partitioned object

1 Answers  


NNO-00327: server statistic counter dump ends

1 Answers  


ORA-26520: internal memory failure

1 Answers  


ORA-24410: scrollable cursor max size exceeded

1 Answers  


DRG-52105: no delete function found

1 Answers  


SQL*Loader-00823: TREAT AS clause for object tables not supported for external tables

1 Answers  


ORA-28101: policy already exists

1 Answers  


Categories