Questions tagged [impdp]

For questions about the Oracle Data Pump Import (invoked with the impdp command). Use together with the [oracle] tag.

Filter by
Sorted by
Tagged with
29
votes
2answers
161k views

How to transfer data using expdp and impdp commands?

I'm an Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump's expdp and impdp commands. I have ...
3
votes
1answer
12k views

Oracle: Full database (user) restore requires drop?

In our development environment (Oracle 11g), we often have to restore databases (users) to previous versions to test upgrades, verify defects, etc. We are using expdp/impdp to perform our backup/...
0
votes
1answer
2k views

Export Data Pump all data from few schemas except one table structure only?

we use to make a copy of schemas from one database and move it to another for testing using this par file ... DIRECTORY=EXPORT DUMPFILE=QQS_PROD.DMP LOGFILE=QQS_PROD.LOG SCHEMAS=QQSDATA_PROD,...