Stack Overflow
Stack Overflow

Questions tagged [datapump]

A server based bulk import and export facility in Oracle

Data Pump Export and Import replace Import and Export. It can be used to import or export tables, schemas or entire databases in a dump file.

Questions tagged should also be tagged .

Further reading:

201 questions
0
votes
1 answer

How to do a backup in oracle with data and without data?

I have been asked to make a backup of type export: full or schema and default, structure and only data in oracle. I found these example commands to backup database and schema expdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR…
G16
  • 33
  • 1
  • 5
0
votes
1 answer

Data Pump export using cloud shell

I am trying to export schema using data pump on Oracle Cloud Autonomous database. I am using cloud shell to export schema. When I tried to do the final step: expdp admin/password@DB_HIGH schemas=SCHEMA_NAME directory=data_pump_dir dumpfile=exp%U.dmp…
Goku
  • 441
  • 5
  • 20
0
votes
1 answer

how to import a dmp file with profiles from a CDB db to a PDB DB instance using impdp in Oracle 12c?

I have a dmp file from a CDB(don't know exactly) in another server from where, I was given a dmp file which was exported using expdp(possibly). I want to import it into a PDB instance on an Oracle 12c server which I have. I extracted the sql file…
Jithu Paul
  • 154
  • 2
  • 15
0
votes
1 answer

(Oracle) Data Pump compatibility?

I'm currently experimenting van different versions of Data Pump. (Oracle) We have a bunch of dev oracle servers at work. Versions 11, 12, 18 and 19. If I recall correctly, Oracle 19 should be backwards compatible with 18, 12 and 11. I can…
mk94817
  • 1
0
votes
1 answer

dbms_datapump on AWS RDS: ORA-28031: maximum of 150 enabled roles exceeded

Scenario AWS RDS Oracle DB instance master user runs export full database with dbms_datapump. This error appears after all the data gets copied out: ORA-28031: maximum of 150 enabled roles exceeded Backtrace ORA-39126: Worker unexpected fatal error…
Brian Fitzgerald
  • 634
  • 7
  • 14
0
votes
0 answers

How to use datapump in SQLDEVELOPER EC2 WINDOWS

I am in the process of migrating from Oracle 11g on premise to AWS RDS ORACLE 19C. to connect to my target database, I installed SQL DEVELOPER on an EC2 Windows Server instance. I am running the following script and I have an error. help me…
Edji
  • 1
  • 1
0
votes
1 answer

Oracle Import Data dump: tablespace: "USERS" already exist

I am trying to import data using impdp in oracle. However, when I tried to import it, it is giving me the following error: ORA-29349: tablespace "USERS" already exists Since USERS is the defualt permenant tablespace that contains users objects, I…
AngryOtter
  • 149
  • 9
0
votes
1 answer

"ORA-22814: attribute or element value is larger than specified in type" error in export to 11.2 format

System Patch Level: 28790651;OJVM RELEASE UPDATE: 12.2.0.1.190115 (28790651) 28870605;OCW JAN 2019 RELEASE UPDATE 12.2.0.1.190115 (28870605) 28822515;Database Jan 2019 Release Update : 12.2.0.1.190115 (28822515) expdp system@pdb1 TABLES=tbl…
Elnara Mustafayeva
  • 1
  • 3
0
votes
0 answers

Data Pump import fails with "job does not exist"

Can anyone help with this problem? I'm trying to use datapump to load a dump file created but whenever I try, I get the following code: DECLARE hdnl NUMBER; status VARCHAR2(20); BEGIN hdnl := dbms_datapump.open (operation => 'IMPORT', job_mode =>…
amir
  • 331
  • 2
  • 9
  • 20
0
votes
0 answers

Imported table from datapump utility is of less size and have fewer rows than it was exported?

I have a data dump file which was created through EXPDP utility in oracle 11g. The log file of export is as: ;;; Export: Release 11.2.0.4.0 - Production on Fri Oct 30 19:00:03 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All…
chandersheel
  • 35
  • 6
0
votes
1 answer

Export tables from different schemas using DBMS_DATAPUMP api

I have a requirement to export tables from different schemas using DBMS_DATAPUMP api. Below script is getting failed after exporting 0.5 GB data with below errors: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS…
user8417657
  • 1
  • 1
0
votes
0 answers

Column not copied with transportable tablespace

I have a tablespace that I copy from one Oracle instance to another. I use transportable tablespace to do so. The problem I have is that values of 2 columns in a table are not being copied in the new tablespace. I have a table with 57 columns. 2…
pmartin8
  • 1,545
  • 1
  • 20
  • 36
0
votes
0 answers

Oracle DATAPUMP import failed

I am currently trying to import a database using DBMS_DATAPUMP in PL/SQL using the following script. DECLARE h1 NUMBER; BEGIN h1 := DBMS_DATAPUMP.OPEN('IMPORT', 'FULL', NULL, DBMS_SCHEDULER.generate_job_name, 'LATEST'); …
Nemo
  • 1
  • 1
  • 3
0
votes
1 answer

Transportable Tablespaces, DataPump, Golden Gate & a View with DB_Link which is best?

Version of Oracle 12c Enterprise Edition release 12.1.0.2.0 Current process. Database 1 I have two Cursor SQL queries (which join a number of tables) which basically write to a flatfile (both files have a similar file format) using a PL/SQL for…
Shaun Kinnair
  • 495
  • 2
  • 10
  • 27
0
votes
1 answer

Oracle 12c import dump with user profiles & roles

I'm trying to import dump file I received from customer. The customer defined the schema on user with Profile and Role which obviously do not exist in my Database and are not required by me. Whenever I do impdp I get multiple errors: ORA-02380:…
Michal
  • 11
  • 1
  • 4
1 2 3
…
13 14