--创建用户
create user wentao0121 identified by wentao0121;
--创建表空间
create tablespace ts_wentao0121 datafile 'D:\oracle\tablespace\wentao0121-data.dbf' size 100m;
--修改表空间
alter user wentao0121 default tablespace ts_wentao0121;
--给用户授权
grant create session, create table,create sequence,create view,unlimited tablespace to wentao0121;
----------------------------------------------
--导出:
exp pms/pms@db26 file=1224.dmp
--导入:
imp security/security@orcl2 fromuser=pms touser=security file=c:\1224.dmp
create user wentao0121 identified by wentao0121;
--创建表空间
create tablespace ts_wentao0121 datafile 'D:\oracle\tablespace\wentao0121-data.dbf' size 100m;
--修改表空间
alter user wentao0121 default tablespace ts_wentao0121;
--给用户授权
grant create session, create table,create sequence,create view,unlimited tablespace to wentao0121;
----------------------------------------------
--导出:
exp pms/pms@db26 file=1224.dmp
--导入:
imp security/security@orcl2 fromuser=pms touser=security file=c:\1224.dmp