Oracle Import DMP Whole process

CREATE TABLE Space
Create Tablespace BOSS
Tempfile ' d:/oraclexe/boss.dbf '
Size 500M
Autoextend on next 50M maxsize 4000M;

Delete Table space
Drop tablespace BOSS including contents and datafiles


modifying character sets
ALTER SYSTEM ENABLE RESTRICTED SESSION;

ALTER SYSTEM SET job_queue_processes=0;

ALTER SYSTEM SET aq_tm_processes=0;

--If you are from a subset to a parent set, you need to use the Internal_use parameter to skip the hyper-subset detection
ALTER DATABASE CHARACTER SET internal_use ZHS16GBK;

ALTER DATABASE National CHARACTER SET internal_use al16utf16;


CREATE USER Ovtboss identified by Ovtboss;

Allocation table Space
Alter user Ovtboss default Tablespace BOSS;

Grant DBA to Ovtboss;

Imp ' Sys/manager as Sysdba ' file= "20160514_ovtboss.dmp" Fromuser=ovtboss touser=ovtboss ignore=y

Oracle Import DMP Whole process