PL/SQL developer import dump

oracle dump plsqldeveloper tablespace
Mikayil Abdullayev picture Mikayil Abdullayev · May 28, 2011 · Viewed 26k times · Source

I have a dump file which includes two tables. Now I need to import this dump file. I was instructed to create two tablespaces beforehands.Now how do I import this dump file to these tablespaces. I'm using PL/SQL developer.

Answer

Codo picture Codo · May 28, 2011

You cannot import a dump file from PL/SQL developer. Instead, you have to do it from the command line. Furthermore, you need access to the file system of the database server since you have to put the dump file in a directory directly accessible by Oracle.

The tool to import the dump file is called impdp (in earlier version, it was imp).

My experience is that you need information how the dump file was created so you can use the correct import mode:

  • Is it a dump of the full database or just a single user/schema?
  • Does it include the table schema or just the table data?
  • What's the schema/user name if a single schema was exported?
  • etc.

You'll find more information about impdp on this PSOUG web page.

Related questions

Migrate from Oracle to MySQL

We ran into serious performance problems with our Oracle database and we would like to try to migrate it to a MySQL-based database (either MySQL directly or, more preferably, Infobright). The thing is, we need to let the old and …

Read More
Determining the NLS_LANG setting for an existing Oracle database dump file

We were handed a dump file by another team who are gone away for the rest of the year. When we try to import the dump into our own database, we get the following error: IMP-00038: Could not convert to …

Read More
Dumping CLOB fields into files?

Say you have the table: Column_name | data_type Title | Varchar2 Text | CLOB with some rows: SomeUnkownMovie | A long time ago in a galaxy far, far away....(long text ahead) FredMercuryBio | Awesomeness and stuff....(more long text) Is there a …

Read More