Top "Impdp" questions

How to change Oracle default data pump directory to import dumpfile?

I'm using impdp to import a backup. But I want change default directory dumpfile. $ impdp system/password@$ORACLE_SID schemas=…

database oracle impdp

Importing selective data using impdp

I have an entire DB to be imported as a dump into my own. I want to exclude data out …

oracle import impdp

Oracle: importing data pump dump without knowledge dump file content

Old approach for exporting/importing whole schema: exp user/pwdp@server FILE=export.dmp OWNER=user ROWS=Y imp newuser/…

import oracle10g impdp

Oracle import dump file throwing ORA-39088 error

I am trying to import data from a dump file created by Oracle 10g data pump utility. The command that …

oracle import impdp oracle-dump

Migrating Oracle Database with expdp and impdp

Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a …

oracle oracle11g database-migration impdp

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 …

oracle11g datapump impdp

Oracle data pump import into existing table

i need an efficient way to copy data from one database to another. Both are based on Oracle 11g. Step: (…

sql oracle datapump impdp

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_…

oracle schema remap ora-00942 impdp

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: …

database oracle datapump impdp

impdp content=data_only, how to specify which tables to import first

I am trying to import my database using the command impdp SYSTEM/password DIRECTORY=dmpdir DUMPFILE=database.dmp CONTENT=DATA_…

oracle impdp