命令创建、删除表空间,创建、授权用户,导入数据

2014-11-24 08:04:36 ? 作者: ? 浏览: 1
命令创建、删除表空间,创建、授权用户,导入数据
create tablespace zcxm6 datafile 'E:\app\tablespace\hn3.dbf' size 300m autoextend on
next 10m maxsize unlimited;
create user name identified by orcl default tablespace zcxm6;
grant connect,resource,dba to name;
imp userid=name/password full=y file=F:\datasource\hncq_zcxm6_0315.dmp
DROP TABLESPACE tablespacename INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
drop user username cascade;
-->

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: