创建表空间
create tablespace TS
datafile 'D:\oracle\oradata\ts.dbf'
size 500m
autoextend on;
select username,default_tablespace from dba_users order by username
1、导出tcd数据库
exp tcd/password@ORCL file=D:\databackup\20180321\wgq_tcd_20180321.dmp full=y
2、导入tcd数据库
登录sys管理员
sqlplus sys/admin as sysdba;
drop user tcd cascade;或者用plsql删除用户
重新创建用户;
--创建用户
create user tcd
identified by password
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
password expire;
--赋予角色权限
grant connect,resource to tcd;
--grant dba to tcd;
grant unlimited tablespace to tcd;
imp tcd/password@ORCL full=y file=D:\databackup\20180321\wgq_tcd_20180321.dmp ignore=y
imp tcd/password@ORCL full=y file=E:\0180607\wgq_tcd_20180607.dmp ignore=y