dexpdp USERID="SYSDBA/SYSDBA_123456@localhost:5329"
FILE=ASSET_BASE_ASSET.dmp
DIRECTORY=/mnt/tiger/dexp-data
TABLES="FS_SC_SZXC.ASSET_BASE_ASSET"
LOG=check_ASSET_BASE_ASSET.sql \
dimpdp USERID="SYSDBA/SYSDBA1@localhost:5330"
FILE=ASSET_BASE_ASSET.dmp
DIRECTORY=/mnt/tiger/dexp-data
TABLES=FS_SC_SZXC.ASSET_BASE_ASSET
TABLE_EXISTS_ACTION=REPLACE
REMAP_SCHEMA=FS_SC_SZXC:N_FS_SC_SZXC
REMAP_TABLESPACE=MAIN:N_FS_SC_SZXC_ASSET_TS
LOG=import_ASSET_BASE_ASSET.log \
执行时如下:
[dmdba@k8s-node3 dexp-data]$ dimpdp USERID="SYSDBA/SYSDBA1@localhost:5330" \
FILE=ASSET_BASE_ASSET.dmp
DIRECTORY=/mnt/tiger/dexp-data
TABLES=FS_SC_SZXC.ASSET_BASE_ASSET
TABLE_EXISTS_ACTION=REPLACE
REMAP_SCHEMA=FS_SC_SZXC:N_FS_SC_SZXC
REMAP_TABLESPACE=MAIN:N_FS_SC_SZXC_ASSET_TS
LOG=import_ASSET_BASE_ASSET.log
;
dimpdp V8
[警告]请指定导入TABLE
=================
请问正确的语句应该是怎么样的?
我在本地简单做了个测试,没有问题
逻辑导出 [dmdba@shine ~]$ dexpdp USERID=SYSDBA/'"Dameng@!23"'@localhost:5236 \ > FILE=TESTTABLE.DMP \ > DIRECTORY=/home/dmdba \ > TABLES=TEST.TEST \ > LOG=TEST_EXP.LOG dexpdp V8 ---- [2025-06-17 10:38:04]export table:TEST ----- export the privilege of the table... table :TEST export terminate, total export 9 rows all the export process spent total 0.034 s terminate export success without warning 删除表 [dmdba@shine ~]$ disql SYSDBA/'"Dameng@!23"'@localhost:5236 Server[localhost:5236]:mode is normal, state is open login used time : 8.825(ms) disql V8 SQL> drop table TEST.TEST; executed successfully used time: 26.014(ms). Execute id is 20600. SQL> exit 逻辑导入 [dmdba@shine ~]$ dimpdp USERID=SYSDBA/'"Dameng@!23"'@localhost:5236 \ > FILE=TESTTABLE.DMP \ > DIRECTORY=/home/dmdba \ > TABLES=TEST.TEST \ > LOG=TEST_IMP.LOG dimpdp V8 local code: PG_UTF8, dump file code: PG_UTF8 ----- [2025-06-17 10:38:57]import table:TEST ----- create table TEST creating table is complate, table TEST data is importing... import table TEST , has coped with 9 rows all the import process spent total 0.101 s terminate import success without warning 查看表 [dmdba@shine ~]$ disql SYSDBA/'"Dameng@!23"'@localhost:5236 Server[localhost:5236]:mode is normal, state is open login used time : 8.959(ms) disql V8 SQL> select * from TEST.TEST; LINEID ID NAME ---------- ----------- ------- 1 1 ABCDEFG 2 2 ABCDEFG 3 3 ABCDEFG 4 4 ABCDEFG 5 5 ABCDEFG 6 6 ABCDEFG 7 7 ABCDEFG 8 8 ABCDEFG 9 9 ABCDEFG 9 rows got used time: 2.102(ms). Execute id is 21000. SQL>