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...

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 schem...

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...

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 pat...

Recently, we took a live/online backup of our production database, by issuing the following command: expdp system/******@SID FULL=y DIRECTORY=data_pump_dir DUMPFILE=full_prod.dmp LOGFILE=full_prod...

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 : ba...

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 "s...

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 us...

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" ...

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 ident...

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.

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 ...

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?