Here , When you use below import command,
impdp userid=schema/pass@db statistics=none full=N schemas=(schema_name) tables=TEST_TABLEdirectory=TEST_DIR dumpfile=SCHEMA_BACKUP.DMP logfile=SCHEMA_BACKUP.log
You will be shown error as
UDE-00010: multiple job modes requested, schema and tables.
Solution with Example: Use only one parameter like SCHEMAS or TABLES.
When Parameter file are like ..
SCHEMAS=schema_name
DIRECTORY=TEST_DIR
DUMPFILE=SCHEMA_BACKUP.dmp
LOGFILE=SCHEMA_BACKUP.log
TABLES=TEST_TABLE1,TEST_TABLE2
So, full command will be like
impdp userid=schema/pass@db statistics=none full=N tables=TEST_TABLEdirectory=TEST_DIR dumpfile=SCHEMA_BACKUP.DMP logfile=SCHEMA_BACKUP.log
