oralce的创建用户及数据的迁移

/*分为四步 */

/*第1步：创建临时表空间 */
create tablespace demo
tempfile ‘D:\oracl\app\oracle\oradata\XE\demo.dbf’
size 50m
autoextend on
next 50m maxsize 20480m
extent management losyscal;

/*第2步：创建数据表空间 */

create tablespace wholesale

logging
datafile ‘D:\oracl\app\oracle\oradata\XE\wholesale.dbf’
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

/*第3步：创建用户并指定表空间 */
create user wholesale identified by 801005
default tablespace wholesale
temporary tablespace temp;

/*第4步：给用户授予权限 */
grant connect,resource,dba to wholesale;

案例
[root@kemis-test XE]# su oracle
bash-4.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on 星期四 6月 27 11:22:48 2019
Copyright © 1982, 2011, Oracle. All rights reserved.
连接到:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> create tablespace wholesale
2 logging
3 datafile ‘/u01/app/oracle/oradata/XE/wholesale.dbf’
4 size 50m
5 autoextend on
6 next 50m maxsize 20480m
7 extent management local;
表空间已创建。
SQL> create user wholesale identified by 801005
2 default tablespace wholesale
3 temporary tablespace temp;
用户已创建。
SQL> grant connect,resource,dba to wholesale;
grant connect,resource to erp
授权成功。

数据的导入

imp ec180904/12345671@192.168.20.95:5555/oadb file=D:\ee1x.dmp full=y

exp ec180904/12345671@192.168.20.95:5555/oadb file=D:\ec180904.dmp owner=(ec180904)

导入命令：impdp user/passwd directory=EXPDP dumpfile=wholesale_xxxxxxxx.dmp REMAP_SCHEMA=source_schema:target_schema REMAP_TABLESPACE=source_tablespace:target_tablespace、
案例：
impdp wholesale/801005 directory=EXPDP dumpfile=wholesale_20190627.dmp REMAP_SCHEMA=wholesale:wholesale REMAP_TABLESPACE=wholesale:wholesale