Oracle导出导入dmp文件命令,以及excel生成32位uuid

Oracle导出dmp文件命令,以及excel生成64位uuid

导出命令cmd中

expdp mms/xfkjerp@orcl schemas=mms dumpfile=expdp.dmp DIRECTORY=DATA_PUMP_DIR

生成64位小写uuid

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))

oracl导入数据DMP文件

###1.删除已有数据库xfkjerp

2.创建数据库xfkjerp

3.打开cmd

sqlplus /nolog

​

conn sys/cape as sysdba

-- 创建表空间
create tablespace mms datafile 'c:\oracle\xfkjerp\mms.dbf' size 100m autoextend on next 10m; 

-- 创建用户
create user mms identified by cape default tablespace mms;

-- 授权给用户
grant dba to mms;

-- 导入相应的数据库表备份文件
impdp mms/cape@xfkjerp DIRECTORY=DATA_PUMP_DIR DUMPFILE=MDB20190702.DMP  SCHEMAS=mms

转载于:https://my.oschina.net/u/4163171/blog/3073875