Oracle CREATE table Create library data recovery

--Build users
CREATE USER Szs identified by Szs DEFAULT tablespace nn_data01 temporary tablespace temp;
--User empowerment
GRANT connect,dba to Szs;
GRANT CREATE synonym,create PROCEDURE,
CREATE sequence,create session,create table,create trigger,create VIEW to Szs
--Delete User
--drop user tt0907 Cascade;
--Guide Table
--imp Szs/[email protected] file=f:\szs_nn\2015010650dmp.dmp full=y ignore=y log=e:\imp.log buffer=1024000
--imp Szs/[email protected] file=f:\szs_nn\2015010650dmp.dmp full=y ignore=y log=f:\log buffer=4096000
--exp Tly0917/[email protected] file=f:\nc611.dmp owner=tly0917 Log=f:\exp.log
--exp tly0917/[email protected]_192.168.0.2 file=d:\20121215.dmp owner=tlyhftp0917 log=F:\exp.log

--11G Data Pump recovery statement
Create directory Szs1 as ' F:\szs_nn\20140905adms\ ';
--View Catalog
SELECT * from Dba_directories;
--Assigning permissions
Grant Read,write on directory szs1 to Szs;
Grant all on directory Szs to public;
--Create a local directory D:\bak, and put the data files that need to be restored into the directory of the original schema NC import Dzbank
IMPDP Szs/[email protected] Directory=szs dumpfile=20140915adms.dmp REMAP_SCHEMA=SZS:NC50 full=y logfile=orcl.log Show =y
--11G exp Export table when setting empty table export
--Note: This value is set after the empty table that was previously imported does not work, still cannot export, can only affect the new table later
Alter system set DEFERRED_SEGMENT_CREATION=FALSE Scope=both;
--11G Export Statements
EXPDP N6/[email protected] dumpfile=n6.dmp directory=dpath logfile=n6.log version=10.2.0.0

--11g set tablespace default size file above 32G large file (set before table space is established)
ALTER DATABASE set default Bigfile tablespace;
--Build table space
Create tablespace nnc_data01 logging datafile ' nnc_data01.dbf ' size 300m autoextend on next 50m maxsize unlimited;
Create tablespace nnc_data02 logging datafile ' nnc_data02.dbf ' size 100m autoextend on next 50m maxsize unlimited;
Create tablespace nnc_data03 logging datafile ' nnc_data03.dbf ' size 100m autoextend on next 50m maxsize unlimited;
Create tablespace nnc_index01 logging datafile ' nnc_index01.dbf ' size 300m autoextend on next 50m maxsize unlimited;
Create tablespace nnc_index02 logging datafile ' nnc_index02.dbf ' size 100m autoextend on next 50m maxsize unlimited;
Create tablespace nnc_index03 logging datafile ' nnc_index03.dbf ' size 100m autoextend on next 50m maxsize unlimited;

Oracle CREATE table Create library data recovery