oracle資料庫建表

標籤：oracle   pass   impdp   登入   user   use   刪除   asc   director   

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;
資料泵匯入
impdp hfzt/[email protected] dumpfile =YDXT-20161011.DMPDP logfile=YDXT-20161011.log directory=dumpdir
資料泵匯出
expdp pgys/[email protected] directory=dumpdir dumpfile=pgys20161213.dmp logfile=pgys20161213.log

刪除使用者
drop user ×× cascade
以dba方式登入
sqlplus /nolog
conn sys/[email protected]資料庫 as sysdba
或者
sqlplus "/as sysdba"

oracle資料庫建表