I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into the Test Server by providing a new Schema Name as part of my restoration Tests.
So how can i do that. The source is 12c Server on Linux and Destination is 12c Server on Linx as well.
You can import only single schema from your dump file by using "schemas" parameter. Also, you can import the schema into non-original name.
For example, if you want to import schema MY_SCHEMA into MY_NEW_SCHEMA use this command:
impdp system/password dumpfile=full.dmp logfile=full.imp_log schemas=MY_SCHEMA remap_schema=MY_SCHEMA:MY_NEW_SCHEMA
Omit remap_schema if you want to import into the same schema
