Import Oracle database dump

Hello,

Today we will see how to import oracle dumped database.

CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M     ONLINE;

1	CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M ONLINE;

2. Create <user>

CREATE USER <username> IDENTIFIED BY <password>;

1	CREATE USER <username> IDENTIFIED BY <password>;

3. give him dba access :

GRANT dba TO <username> WITH ADMIN OPTION;

1	GRANT dba TO <username> WITH ADMIN OPTION;

4. copy dump into the dump directory :

mv oracle_dump.DMP /u01/app/oracle/admin/XE/dpdump/

1	mv oracle_dump.DMP /u01/app/oracle/admin/XE/dpdump/

5. Finally, launch the dump :

impdp <username>/<password> dumpfile=oracle_dump.DMP logfile=out.log full=y;

1	impdp <username>/<password> dumpfile=oracle_dump.DMP logfile=out.log full=y;