Oracle Database Discussions

Hey guys
I am fairly new to using impdp and expdp and wondered if anyone knew a solution to my little problem. I am currently using expdp in parallel mode, which creates multiple DMP files. Now when I use impdp, i use the following code:

impdp stglsr/stglsr@tintdb tables=CTDA0FIL_CDC CONTENT=ALL directory=LSR_DQA_REPORTS dumpfile=CTDA0FIL_CDC_01.dmp,CTDA0FIL_CDC_02.dmp logfile=CTDA0FIL_CDC_IMP.log

As you can see I am entering each of the files to import. As this is going to be run by someone else and I cant guarantee how many files the export is going to produce, is there a way of just saying import all files associated with a particular export rather than specifying the files to import individually.


- Please find below an example of my export:

expdp stglsr/stglsr@tintdb parfile=ctca0fil_export.par


- Par File:

TABLES=CTCA0FIL_CDC
DUMPFILE=CTCA0FIL_CDC_%U.dmp
CONTENT=ALL
DIRECTORY=LSR_DQA_REPORTS
LOGFILE=CTCA0FIL_CDC.log
PARALLEL=4
QUERY= CTCA0FIL_CDC:"where ETL_STATUS ='E'"
JOB_NAME=CTCA0FIL_EXP_JOB

If anyone can help I would be most grateful.

Thanks
Simon