how to use remap_schema and limit the import to a single user

Using oracle 11gR2 on windows server 2003r2.

Trying to import a schema into a different schema name:

impdp system/password@database REMAP_SCHEMA=olduser:newuser directory=DATA_PUMP_DIR dumpfile=dumpfile.dmpdp logfile=impdp.log

When I run this, it looks like it's trying to import ALL the data, not just the olduser data (into newuser).

What is my impdp command missing?

Thanks.
gateguardAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Add: schemas=olduser
0
 
gateguardAuthor Commented:
thanks!
0
All Courses

From novice to tech pro — start learning today.