Oracle Database Build Table

Create or replace directory Dumpdir as ' E:\oracle\dumpdir ';
Create temporary tablespace ydxt_temp
Tempfile ' E:\oracle\product\10.2.0\oradata\ydxt\ydxt_temp.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
Create Tablespace YDXT
Logging
DataFile ' E:\oracle\product\10.2.0\oradata\ydxt\ydxt.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;
Create user Ydxt identified by hfzt123456
Default Tablespace YDXT
Temporary tablespace ydxt_temp;
Grant CONNECT,RESOURCE,DBA to YDXT;
Data Pump Import
IMPDP Hfzt/[email protected] dumpfile =ydxt-20161011. DMPDP Logfile=ydxt-20161011.log Directory=dumpdir
Data Pump Export
EXPDP Pgys/[email protected] Directory=dumpdir dumpfile=pgys20161213.dmp Logfile=pgys20161213.log

Delete User
Drop Userxxcascade
Log on as DBA
Sqlplus/nolog
Conn Sys/[email protected] database as SYSDBA
Or
Sqlplus "/as sysdba"

Oracle Database Build table