命令行
cd /home/dmdba/dmdbms/bin
导出:
./dexp SYSDBA/SYSDBA@LOCALHOST:5236 directory=/home/bak file=LASERVICEX.dmp SCHEMAS=LASERVICEX
cd /data/dm/dmdbms/tool
./disql
conn SYSDBA/SYSDBA:5237
create user LASERVICEX identified by LASERVICEX;
sudo root
cd /data/dm/dmdbms/bin
./dimp SYSDBA/SYSDBA@LOCALHOST:5237 directory=/data/tools/dmdb file=LASERVICEX.dmp remap_schema=LASERVICEX:LASERVICEX table_exists_action=replace
cd /data/dm/dmdbms/tool
./disql
conn SYSDBA/SYSDBA:5237
SELECT DISTINCT object_name FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'SCH';
SELECT table_name FROM dba_tables WHERE owner = 'LASERVICEX';
select USER_ID from "LASERVICEX"."SYS_USER" ORDER BY 1 DESC LIMIT 1;
方案一:
删除模式和用户后,重新新建用户后导入
drop user if EXISTS LASERVICEX CASCADE;
方案二:
直接覆盖
./dimp SYSDBA/SYSDBA@LOCALHOST:5237 directory=/data/tools/dmdb file=LASERVICEX-114.dmp remap_schema=LASERVICEX-114:LASERVICEX table_exists_action=replace
====
skip:跳过此表
append:直接向现有表中导入数据
truncate:先删除现有表中的数据,再向表中导入数据
replace:先删除现有表,再导数据
====
参考
https://blog.csdn.net/Mrkill123/article/details/127485219
https://blog.csdn.net/qq_46601767/article/details/113977780
https://www.cnblogs.com/zhaojiu/p/17115553.html
https://blog.csdn.net/qq_44819536/article/details/124235560