Questions tagged [expdp]
For questions about the Oracle Data Pump export (invoked with the expdp command). Use together with the [oracle] tag, and include the appropriate version tag, such as [oracle-12c]. If the question applies to both the impdp and expdp commands, do not use this tag; use [datapump] tag instead.
3
questions
29
votes
3
answers
175k
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 ...
- 5,283
1
vote
2
answers
32k
views
Export pump all schemas except Sytem related schemas
I have around 111 schemas in one database instance and have to export all the schemas except the system related schemas to a new instance. Is there any way as to exclude system related schemas while ...
- 181
0
votes
1
answer
3k
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,...
- 357