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
12
votes
1 answer

ORA_ROWSCN - old/restored blocks don't have a real SCN assigned?

We're using the ORA_ROWSCN pseudocolumn in order to locate recently modified rows for the purposes of replicating selected details over to a different data source. We're aware of the "approximate" nature of this column, that whole batches of rows…
zzzeek
  • 72,307
  • 23
  • 193
  • 185
10
votes
2 answers

Export from Oracle 10g database with 11g client

Database Version : 10g Enterprise Edition Release 10.2.0.4.0 Client Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit) When I try to export (exp) a table from database: exp usr/pass@remote_db file=f.dmp tables=table I get the…
bonsvr
  • 2,262
  • 5
  • 22
  • 33
9
votes
2 answers

How to use Data Pump utilities without a tnsnames.ora file

I want to be able to run expdp and impdp by directly specifying the connection parameters instead of a TNS name that resides in tnsnames.ora. Is this possible?
Shravan
  • 223
  • 1
  • 5
  • 12
8
votes
4 answers

ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings

When I'm trying to run impdp command in sqlplus, I got below error. ORA-31631: privileges are required ORA-39122: Unprivileged users may not perform REMAP_SCHEMA remappings. I have granted IMPORT FULL DATABASE privileged to schema which I'm trying…
Bishan
  • 15,211
  • 52
  • 164
  • 258
7
votes
1 answer

Oracle data pump impdp to remote server

We have a dump file that we want to import to an Amazon rds server. This is what I did: Create a public db link and verify it works: create public database link rdsdblink connect to dbuser identified by dbpsw using…
Cal
  • 747
  • 1
  • 13
  • 30
6
votes
3 answers

oracle data pump import ORA-39002 with ORA-39070, ORA-29283 and others on Windows 10

I am using data pump to perform an import on 4 .dmp files and keep on receiving the set of errors as below: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line…
user9517303
6
votes
1 answer

Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c?

When I run this command in Oracle 12c SE2: impdp system/Oracle_1@pdborcl directory=DATA_PUMP_DIR dumpfile=mydb.dmp nologfile=Y I get this: ORA-39001 : invalid argument value ORA-39000 : bad dump file specification ORA-39088 : directory name…
Sam
  • 4,766
  • 11
  • 50
  • 76
6
votes
4 answers

Oracle 12c datapump error when exporting from 11g database

I am using the following in cmd. expdp system/*****@11.11.1.11:1521/orcl schemas=HR directory=DATADIR dumpfile=HR_20150625.dmp logfile=HR_20150625.log version=11.2 The database from which schema is to be exported is 11g (11.2.0.1.0) The datapump…
Varun Rao
  • 781
  • 1
  • 10
  • 31
6
votes
1 answer

impdp in Oracle. Why it does not create users?

I am newbie in oracle and I am facing troubles with impdp. I have a production server and I have created a new server for testing purposes, so I installed centos, oracle and created the database "sire". Now I make a dump from the production server…
Carlos Antidio Morales
  • 95
  • 1
  • 1
  • 3
6
votes
1 answer

Why is Oracle is locking the statistics of my schema after import?

My problem is that I have a schema where the statistics of all tables are locked. I found on the Internet that I can unlock using the DBMS_STATS.UNLOCK_TABLE_STATS (SCHEMA_NAME) procedure. What I need to know is the how Oracle determines when the…
Aramillo
  • 3,176
  • 3
  • 24
  • 49
6
votes
2 answers

Will Oracle Data Pump affect performance?

Would like to know what would happen if I run data pump on a production server which is being used live. Will this affect DB performance for Update/Insert activities ?? Thank You.
Steven Tang Ti Khoon
  • 479
  • 2
  • 6
  • 17
6
votes
1 answer

Is it possible to export all schemas in a database with oracle data pump?

I am using Oracle 11g 11.2.0.1.0 and I'm trying to find a way of using data pump to export ALL schemas in a database. I know you can specify multiple schemas using the SCHEMAS argument, but I need to be able to export all schemas without having to…
user1578653
  • 4,888
  • 16
  • 46
  • 74
5
votes
1 answer

how to get the oracle database version from dump file

I have a oracle dump file. I want to know the version of the oracle db that the dump file used. e.g. if the dump file is used oracle 11g or oracle 12c
Felix Xie
  • 89
  • 1
  • 9
5
votes
3 answers

Find tablespaces used within datapump dump file

Given an Oracle datapump file is it possible to find/retrieve the used tablespaces without accessing the original/source schema? I tried to use the strings Linux command but I'm unable to find pattern indicating a tablespace. Any idea?
Andrea de Palo
  • 205
  • 1
  • 3
  • 5
4
votes
3 answers

Oracle Data Pump Export script fails

I'm trying to do a data pump export for metadata on a tablespace (COURSE). Am I on the right track? My data pump directory was created as: CREATE DIRECTORY dpump_dir AS '/mydata/data'; Please keep in mind that I'm a beginner. This may or may not be…
relyt
  • 679
  • 6
  • 14
  • 26
1
2 3
…
13 14