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.
63
questions
0
votes
2
answers
6k
views
How to export own objects using expdp without special privileges?
As per this post on Oracle forums expdp can be used to export your own schema without any special privileges:
It all depends on what you want that user to be able to export/import.
If all that ...
- 3,107
1
vote
1
answer
1k
views
Oracle migration unable to create indexes
I want to move the contents of a database instance to another using the expdp and impdp utilities. The source instance is version 12.1.0.1.0 and the destination is 11.2.0.1.0 so I modified the expdp ...
- 157
1
vote
2
answers
2k
views
Are expdp/impdp commands appropriate for daily schema sync?
I've done following comands:
expdp system/password@localdb ^
schemas=SCH directory=dumps_dir dumpfile=SCH_%date%.dmp logfile=expdpSCH_%date%.log
It runs great, without errors. But when I use command:...
- 113
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
1
vote
1
answer
948
views
impdp syntax for schema that is not available on other database
My intention is to import the data of schema 'SCOTT'. I have exported it from db1 using expdp scott/tiger schemas=scott dumpfile=scottexp.dmp ......
Now When I try to import the same in database db2 ...
1
vote
2
answers
25k
views
Oracle Full Client / Database Client package locations
I need to install multiple versions of the Oracle client on an app server for an automation project. The platform I'm looking for in specific is Linux, 64 bit.
Oracle's network of websites are a maze ...
1
vote
1
answer
2k
views
Oracle expdp et impdp : order of schemas?
When I try to export and then import many schemas from one Oracle DB to another one, I get errors because grants and synonyms cannot be recreated in the target DB; the reason is probably that the ...
2
votes
2
answers
7k
views
Expdp error UDE-22303
I am experiencing the following error, when I am trying to make an export to the database using expdmp utility:
UDE-22303: operation generated ORACLE error 22303
OCI-22303: type "SYS"."KU$...
- 29
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
-1
votes
1
answer
8k
views
Importing only one user data from a Dump file
I am using oracle 11gr1 SingleByte Database,
I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly).
example:
. . "...
- 141
0
votes
3
answers
28k
views
Exporting schema data (tables, permisions) into another schema on same database
I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
- 105
2
votes
1
answer
2k
views
Consistent Database Export of Oracle Database
I'm quite confused and I need some clarification!
I do full export of database with Export Pump (for replication/duplication).
What I usually do is:
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP ...
- 357
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,303