Posts made in mai, 2017

Import Oracle database dump

Hello, Today we will see how to import oracle dumped database. Create a tablespace with 2Go memory Shell CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M ONLINE; 1 CREATE TABLESPACE <tablespace name> DATAFILE 'cecm.dbf' SIZE 2048M     ONLINE; 2. Create <user> Shell CREATE USER <username> IDENTIFIED BY <password>; 1 CREATE USER <username> IDENTIFIED BY <password>; 3. give him dba access : Shell GRANT dba TO <username> WITH ADMIN OPTION; 1 GRANT dba TO <username> WITH ADMIN OPTION; 4. copy dump into the dump directory : Shell 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 : Shell 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;      ...