Hi,
I have the below 3 parameter files, and highlighted the key parameters. I have provided my questions after the parameter details, please help me clarify on them.
I'm sorry, I don't have testing environment to try these points by myself before asking here, please bear with me.
test_metadata_only.par
CONTENT=METADATA_ONLY
DIRECTORY=TEST_IMPORT
DUMPFILE=TEST_OWNER_servername_%U.dmp
LOGFILE=Imp_TEST_OWNER_metadata.log
PARALLEL=8
SCHEMAS=TEST_SCHEMA
EXCLUDE=GRANT
EXCLUDE=TABLE:"IN ('TABLE1',
'TABLE2',
'TABLE3',
'TABLE4')"
test_data_only.par
CONTENT=DATA_ONLY
DIRECTORY=TEST_IMPORT
DUMPFILE=TEST_OWNER_servername_%U.dmp
LOGFILE=Imp_TEST_OWNER_data_row.log
PARALLEL=8
SCHEMAS=TEST_SCHEMA
TABLE_EXISTS_ACTION=APPEND
test_data_only_LOG_TABLE.par
CONTENT=DATA_ONLY
DIRECTORY=TEST_IMPORT
DUMPFILE=TEST_OWNER_servername_%U.dmp
LOGFILE=Imp_TEST_OWNER_data_row.log
PARALLEL=8
SCHEMAS=TEST_SCHEMA
TABLE_EXISTS_ACTION=APPEND
QUERY='LOG_TABLE:"WHERE YYYYMM >= 201006"'
1) In the metadata parameter file 'test_metadata_only.par', excluding the list of tables, which we don’t want to get imported, using the EXCLUDE clause.
Want to give the "EXCLUDE=TABLE" clause in multiple lines as given in 'test_metadata_only.par', because we have more number of tables to be provided,
as we cannot give them in a single line. Will it work?
2) The data parameter file 'test_data_only.par' is for loading data. Here, my understanding is in the MetaData import, since we have excluded the unwanted tables,
data will not get imported for them now while using 'test_data_only.par' file. Should we use "EXCLUDE=TABLE" clause in "test_data_only.par" file as well?
3) From the export dump file, want to import data only from LOG_TABLE with the filter condition "YYYYMM >= 201006"
'test_data_only_LOG_TABLE.par' is the parameter file for loading only LOG_TABLE with the filter condition. Will it import only LOG_TABLE for the given criteria?
Thank you.