// 1、创建表空间myspace
create tablespace mysapce
logging
datafile 'D:\ProgramFiles\oracle\product\10.2.0\oradata\orcl\myfile.dbf'
size 100m
autoextend on
next 50m maxsize 8092m
extent management local;
// 2、创建用户myuser并指定表空间myspace
create user myuser identified by mypass
default tablespace myspace
temporary tablespace temp;
// 3、为用户myuser分配DBA权限
grant DBA to myuser;
commit; // 提交
// 4、为用户myuser导入dmp文件,注意导出文件的版本
imp myuser/mypass@orcl file=D:\download\dmpfile_20110224.dmp ignore=y full=y
// 导出指定用户hnsdtest的库
exp hnsdtest/hnsd@192.168.10.219serv file=e:\hnsd201106231450.dmp owner=(hnsdtest)
// 5、修改用户myuser的默认表空间为myspace2
alter user myuser default tablespace myspace2 ;
// 6、删除表空间hnsd
drop tablespace hnsd including contents and datafiles cascade constraints ;
// 7、删除用户hnsdtest
drop user hnsdtest cascade;