表空间操作
drop tablespace CNR_DATA including contents and datafiles;
create tablespace CNR_DATA datafile 'e:/*.dbf' size 50M;
select * from dba_tablespaces;
创建用户
drop user u_name cascade
create user *identified by *default tablespace CNR_DATA;
grant resource,connect,dba to cnr;
select * from user_sys_privs;
select * from dba_users;
导入数据文件(用户下所有对象)
imp username/password@XE file=e:*.dmp FROMUSER= TOUSER=
del e:*.dmp
exp username/password@XE file=e:*.dmp owner=