--1.在cmd命令控制台 导出数据泵文件
CMD> exp sa/eas@orc6651 file=E:\gl\sa.dmp log=sa.log grants=yes owner=sa
--2.以dba用户登录数据库
CMD>sqlplus sys/oracle@orcl as sysdba
在SQL> 执行操作
--2.1创建用户
sql> create user sa identified by eas;
--2.2授权
sql>grant connect,resource,dba to sa;
--2.3创建表空间
sql>create tablespace eas_d_sa_standard datafile 'F:\dbf4orcl_donotdelet\eas_d_sa_standard01.dbf' size 5120m autoextend on next 100m maxsize unlimited extent management local;
sql>create temporary tablespace eas_t_sa_standard tempfile 'F:\dbf4orcl_donotdelet\eas_t_sa_standard01.dbf' size 2048m autoextend on next 100m maxsize 5120m extent management local;
--2.4改变用户的驻留表空间
sql>alter user sa default tablespace eas_d_sa_standard;
sql>alter user sa temporary tablespace eas_t_sa_standard;
--3.在cmd命令控制台 导入数据泵文件
CMD>imp system/oracle@orcl fromuser=sa touser=sa file=E:\gl\sa.dmp log=E:\gl\impsa.log ignore=y
CMD> exp sa/eas@orc6651 file=E:\gl\sa.dmp log=sa.log grants=yes owner=sa
--2.以dba用户登录数据库
CMD>sqlplus sys/oracle@orcl as sysdba
在SQL> 执行操作
--2.1创建用户
sql> create user sa identified by eas;
--2.2授权
sql>grant connect,resource,dba to sa;
--2.3创建表空间
sql>create tablespace eas_d_sa_standard datafile 'F:\dbf4orcl_donotdelet\eas_d_sa_standard01.dbf' size 5120m autoextend on next 100m maxsize unlimited extent management local;
sql>create temporary tablespace eas_t_sa_standard tempfile 'F:\dbf4orcl_donotdelet\eas_t_sa_standard01.dbf' size 2048m autoextend on next 100m maxsize 5120m extent management local;
--2.4改变用户的驻留表空间
sql>alter user sa default tablespace eas_d_sa_standard;
sql>alter user sa temporary tablespace eas_t_sa_standard;
--3.在cmd命令控制台 导入数据泵文件
CMD>imp system/oracle@orcl fromuser=sa touser=sa file=E:\gl\sa.dmp log=E:\gl\impsa.log ignore=y