数据库操作

表空间名：TEST

用户名:user_test

密码：pwd

注：system的密码为pwd

以dba身份登陆数据库，并创建表空间，创建用户，分配权限：
sqlplus sys/pwd as sysdba
create tablespace TEST datafile 'd:\TEST.ora' size 16340m autoextend on next 10M;

alter tablespace  TEST add datafile 'd:\TEST01.ora' size 5000m autoextend on next 10M;

create user user_test identified by pwd default tablespace TEST;
grant connect,resource,sysdba to user_test;
切换到cmd命令行模式下：
imp system/pwd fromuser=user_test touser=user_test file=E:\Company_Work\TEST20101229.dmp  ignore=y;

imp user_test/pwd tables=tbl_cl_jbxx_gcjl1 file=E:\Company_Work\test20101222.dmp  ignore=y;

imp user_test/pwd file=F:\123.dmp  ignore=y;
exp user_test/pwd file=E:\Company_Work\test20101222.dmp

删除表空间
以dba身份登陆数据库
drop tablespace TEST including contents and datafiles cascade constraints;

drop user user_test cascade;