The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
79 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 ...
0
votes
1answer
160 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 ...
1
vote
2answers
258 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 ...
0
votes
2answers
1k 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 ...
0
votes
0answers
161 views

How to know imdp size?

I have a dump file using expdp with compression (oracle version >= 11g). Before running impdp I want to check if there is enough space on the machine but it seems as there is no parameter in the impdp ...
1
vote
1answer
327 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 ...
0
votes
1answer
3k 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 ...
0
votes
0answers
412 views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...
1
vote
1answer
674 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 ...
1
vote
1answer
1k 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$...
0
votes
1answer
945 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,...
-1
votes
1answer
1k 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: . . "...
0
votes
3answers
14k 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.
2
votes
1answer
680 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 ...
12
votes
1answer
87k views

How to transfer data using expdp and impdp commands?

I'm 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 expdp and impdp commands. I have ...