//创建数据表空间 SINOTRANS
create tablespace KD_TABLE_T01 logging datafile 'C:\app\Administrator\oradata\orcl\KDTEST.dbf' size 100m autoextend on next 32m
maxsize 2048m extent management local;
create tablespace gabriel datafile '/home/oracle/oradata/mostdt2/gabriel01.dbf' size 5G
//创建数据表临时空间
create temporary tablespace myc2
tempfile 'F:\oracle\product\10.2.0\myc7.dbf'
size 100m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定密码
create user hanfei identified by hanfei
//授予message用户DBA角色的所有权限
GRANT DBA TO hanfei
//给用户授予权限
grant connect,resource to hanfei(db2:指定所有权限)
//删除表空间
SQL>drop tablespace SINOTRANSincluding contents and datafiles;
--干掉主键被外表关联的表空间
SQL> drop tablespace mytbs02
2 including contents and datafiles cascade constraints;
//修改表空间
SQL>alter tablespace myts03 rename to myts03_new;
//删除用户
drop user myc9 cascade;
//cascade参数是级联删除该用户所有对象,经常遇到如用户有对象而未加此参数则用户删不了的问题,所以习惯性的加此参数
表空间名 KD_TABLE_T01
用户 hanfei
导入案例
imp hanfei/hanfei@orcl file=D:\2014115_2_zskdms.dmp fromuser=hanfei touser='hanfei' full=y buffer=5400000