exp-00026 conflicting modes specified oracle

oracle export par exp
Andrew picture Andrew · Aug 18, 2015 · Viewed 7.2k times · Source

I have below export command for exporting the schema which i want to run in command prompt. When i run this below commnd i am getting an error exp-00026 conflicting modes specified oracle.

exp RATOR_MONITORING/[email protected]/O2P0RTE PARFILE=exp02_rm.par

The exp02_rm.par file has below information:

OWNER=RATOR_MONITORING
LOG=exp02_rm.log
FILE=exp02_rm.dmp
TABLES=KPI_LOGS,ALERT_LOGS
INDEXES=Y
CONSTRAINTS=Y
GRANTS=Y
COMPRESS=Y
FULL=N
ROWS=Y
CONSISTENT=Y
BUFFER=102035256
FEEDBACK=500

Answer

davegreen100 picture davegreen100 · Aug 18, 2015

the error is EXP-00026, which says

" only one parameter (TABLES, OWNER, or FULL) can be specified"

so you can't have both OWNER and TABLES specified as part of the export, one or the either but not both

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
How to see if the background process is complete in SQLDEVELOPER

I have a csv unload process i am running in sqldeveloper, a process window popped up showing the progress of the export and it had an option to run the process in background, I picked the option but now how …

Read More
How to export clob field datas in oracle sql developer

How to export clob field data's in oracle sql developer. Currently clob field data's can't export in oracle sql developer.

Read More