Search code examples
databaseoracle-databaseoracle12cimpdp

impdp doesn't import table data when using exclude parameter

I want to import a DB dump using below command, which will import all the data, but excluding the index and disabling the constraints

impdp FERROVIAL/F3RR0V1AL@FERROVIAL PARFILE=params.par

with the params file containing this params:

DIRECTORY=DB_EXPDP
DUMPFILE=FERROVIAL.DMP
LOGFILE=FERROVIAL.log
REUSE_DATAFILES=YES
EXCLUDE=REF_CONSTRAINT
EXCLUDE=CONSTRAINT
EXCLUDE=table:"='CONTRATOS'"
EXCLUDE procedure, function, package
EXCLUDE=index

But the tables are created but without any data

Solution

  • Since, you have specified parameter REUSE_DATAFILES as YES, then the existing data files would be reinitialized.

    So, you need to set REUSE_DATAFILES = NO or remove this parameter as default value is NO

    REUSE_DATAFILES=YES may result in a loss of data.