Database Utilities (MOSC)

MOSC Banner

Why isn't the remap_schema option working in this instance?

in Database Utilities (MOSC) 6 commentsAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center