Questions tagged [dbms-datapump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
220 views

Recreate existing database with a different charset

I want to change the character set of an existing database from none to utf8, it seems that the safest way is to create a new one then pump data to it. I have tried two methods, both gave me the same ...
-1
votes
1answer
236 views

Datapump export

I'm trying to export the full database using the datapump API, I tried to use this following code: DECLARE handle NUMBER; nom_job varchar(25) := to_char(SYSDATE,'YYYYMMDD_HH24MISS'); nom_dump ...
1
vote
1answer
5k views

Import all database links using dbms_datapump

Source DB version: 11.2.0.3 Destination DB version: 12.1.0.2 I'm attempting to import all database links from one database to another using dbms_datapump. The code is running on the above ...
3
votes
1answer
3k views

dbms_datapump API exclude statistics during import

We are using dbms_datapump to copy data between different servers or to setup new schemas quickly. However importing statistics usually takes ages and has the additional disadvantage that schema ...