Why isn't the remap_schema option working in this instance?
I am testing the recovery of data from a 1.3T table.To test, I am using a different schema and a table of a very much smaller size. Below is what I have done to import the table from one schema to another:
Created a schema, test88, and a user test88/password
This is the import script:
[10:57:05] [oracle@DT dpdump]$ more impdpTest88.bash
#!/bin/bash
date
impdp system/password tables=nspires_prod.assigned_response DIRECTORY=DATA_PUMP_DIR\
JOB_NAME=TEST1 LOGFILE=impdp_test88.log\
REMAP_TABLESPACE=NSPIRES_PROD:TEST88\
TABLE_EXISTS_ACTION=SKIP\
DUMPFILE=expdp_assignedResponse.dmp
date
The remap_schema from nspires_prod to test88 is not working. The result is: