oracle 常用语句

----- 创建表空间
create tablespace data_TABLESPACE
logging  
datafile 'D:\APP\ADMINISTRATOR\ORADATA\WEAIRS\DATA.DBF' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

---创建用户

create user test identified by test default tablespace data_TABLESPACE;

---赋值权限

grant sysdba to test;

grant connect,resource,dba to test；

grant all privileges to test

grant all privileges to zr_da_gz

 

imp test/test@tool file=d:\data.dmp fromuser=test touser=test log=d:\imp.log tablespaces=data_TABLESPACE

exp test/test@TestDB file=E:/test20.dmp owner=test log=d:\exp.log