Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [dbms-datapump]

The tag has no usage guidance.

0
votes
1answer
165 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
212 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 ...
0
votes
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 ...