we use to make a copy of schemas from one database and move it to another for testing using this par file ...
DIRECTORY=EXPORT DUMPFILE=QQS_PROD.DMP LOGFILE=QQS_PROD.LOG SCHEMAS=QQSDATA_PROD,QQSREPOSITORY_PROD,QQS_CENTRAL_PROD,QQS_BD_PROD,QQS_QD_PROD FLASHBACK_TIME=SYSTIMESTAMP EXCLUDE=TABLE:"IN ('SYS_HISTORY')"
then create the CONFIG_HISTORY with a script on the target database!
is there any way to NOT EXCLUDE=TABLE:"IN ('SYS_HISTORY')" and export the structure only of this table?
can I use something like this:
INCLUDE=TABLE:"IN ('SYS_HISTORY')" QUERY=SYS_HISTORY:"where CON_ID < 0"
note: there is no CON_ID with value less than 0, it will return nothing when CON_ID < 0!