Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


EXP-00035: QUERY parameter valid only for table mode exports



EXP-00035: QUERY parameter valid only for table mode exports..

Answer / guest

Cause: You specified the QUERY parameter in an export
command, but you are not performing a table mode export. The
QUERY parameter cannot be used for a user mode export, a
full export, nor a point in time recovery export.

Action: If you want to select a subset of rows for a table,
you must export the table independently with a table mode
export. Issue a table mode export command that specifies the
table name and the query you want to execute during export.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02460: Inappropriate index operation on a hash cluster

1 Answers  


TNS-00121: Missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


PCB-00233: Table size mismatch in INTO/USING. Minimum is: number

1 Answers  


ORA-30744: "string" is not an object table

1 Answers  


ORA-28103: adding a policy to an object owned by SYS is not allowed

1 Answers  






ORA-25134: keyword TABLE expected

1 Answers  


NZE-28818: No package context provided.

1 Answers  


TNS-12619: TNS:unable to grant requested service

1 Answers  


ORA-31629: unable to allocate additional memory

1 Answers  


ORA-24377: invalid OCI function code

1 Answers  


RMAN-08113: including current SPFILE in backupset

1 Answers  


ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


Categories