oracle创建用户

1.创建表空间

SQL> create tablespace test datafile 'D:\oracle\oradata\TEST01.dbf' size 1024M autoextend on next 5M maxsize 2048M;

2.创建用户

SQL> create user test identified by test default tablespace test;

3.授权

SQL> grant connect, resource, dba to test;

SQL> grant create session to test;

4.导入数据

imp test/test@local_test fromuser=test touser=test file=F:\test.DMP log=F:\1.log

create directory dumpdir as 'f:/dmp'

impdp sys/sys@mydb directory=dumpdir dumpfile=*.dmp full=y  logfile=f:\1.log

http://blog.csdn.net/starnight_cbj/article/details/6792364

http://www.cnblogs.com/netsql/articles/1745978.html

5.删除用户

SQL> drop user accountuat cascade;

6.删除表空间

drop tablespace zfmi including contents and datafiles cascade constraints;