Importing Oracle DMP files on a Linux server

Import Library:

Prepare beforehand:

1. Ensure that Oracle is installed correctly on the Linux server

2, Oracle client, capable of connecting to Oracle on server.

Start Step:

1, CREATE table space (table space is more common will give you a script to create a tablespace.) such as Createspace-for-windows.sql).

2, login to the Linux server, such as SSH 192.168.20.222, enter the user name password. Default User name is root

3, enter su-oracle Note, do not enter into Su Oracle.

4, move the DMP files that need to be imported to the Linux server. Like putting files under the \admin\orcl\dpdump directory

(Note: Query oralce default backup Restore directory: SELECT * from dba_directories; generally \admin\orcl\dpdump)

5,CD to \admin\orcl\dpdump Directory

6, enter IMPDP Directory=data_pump_dir dumpfile=xxxx.dmp here xxxx.dmp is the file that needs to be imported.

7, pop-up box prompt for user name password, such as user name Sys

8, wait for the import to complete. If the file is larger it may wait longer.

--------------------------------------------------------------------------------------------------------------- -------------------

Note: This is only for EXPDP exported files.

Importing Oracle DMP files on a Linux server