Import PL / SQL import dump

Question

I have a dump file that contains two tables. Now I need to import this dump file. I was tasked with creating two tablespaces beforehands.Now, how do I import this dump file into these tablespaces. I am using a PL / SQL developer.

Answer 1

You cannot import a dump file from a PL / SQL developer. Instead, you should do this from the command line. In addition, you need access to the database server file system, since you must place the dump file in a directory directly accessible by Oracle.

impdp ( imp).

, , , :

• /?
• ?
• /, ?
• .

impdp PSOUG.

Answer 2

PL/SQL-. → ... → ( ) "".