Search code examples
oracle-databaseexportparexp

exp-00026 conflicting modes specified oracle


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/RATOR_MONITORING@10.127.666.777/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

Solution

  • 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