为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:```language
[dmdba@localhost dmdb8]$ /dmdb8/dmdbms/bin/disql SYSDBA:5237
password:
Server[LOCALHOST:5237]:mode is normal, state is open
login used time : 2.712(ms)
disql V8
SQL> create table test(id int);
executed successfully
used time: 7.464(ms). Execute id is 1000.
SQL> insert into test values(1);
affect rows 1
used time: 0.819(ms). Execute id is 1001.
SQL> commit;
executed successfully
used time: 0.502(ms). Execute id is 1002.
SQL> exit
[dmdba@localhost dmdb8]$ /dmdb8/dmdbms/bin/disql SYSDBA:5237^C
[dmdba@localhost dmdb8]$ cd /dmdb8/
[dmdba@localhost dmdb8]$ ls -l
total 0
drwxr-xr-x. 2 dmdba dinstall 6 Oct 16 14:47 dmarch
drwxr-xr-x. 4 dmdba dinstall 28 Oct 16 19:23 dmbak
drwxr-xr-x. 3 dmdba dinstall 18 Oct 16 15:14 dmdata
drwxr-xr-x 18 dmdba dinstall 291 Nov 25 14:15 dmdbms
drwxr-xr-x 2 dmdba dinstall 64 Nov 25 15:11 dmexp
drwxr-xr-x. 3 dmdba dinstall 23 Oct 16 19:13 dmlog
drwxr-xr-x. 2 dmdba dinstall 6 Oct 16 14:47 dmtmp
[dmdba@localhost dmdb8]$ cd dmexp/
[dmdba@localhost dmexp]$ ls -l
total 204
-rw-r--r-- 1 dmdba dinstall 202671 Nov 25 15:11 fuwa_2023-11-25.dmp
-rw-r--r-- 1 dmdba dinstall 1849 Nov 25 15:11 fuwa_exp_2023-11-25.log
[dmdba@localhost dmexp]$ rm -rf *
[dmdba@localhost dmexp]$ dexp sysdba/sysdba@localhost:5237 file=fuwa_date +%F
.dmp log=fuwa_exp_date +%F
.log directory=/dmdb8/dmexp/ full=y
dexp V8
export NO. 1 SYSPACKAGE_DEF : SYSTEM_PACKAGES
export NO. 2 SYSPACKAGE_DEF : SYS_VIEW
----- export total 2 SYSPACKAGE_DEF -----
----- export total 0 SYSPACKAGE_DATA -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
----- export total 0 USER -----
----- export total 0 ROLE -----
----- export total 0 CONTEXT -----
----- export total 0 DIRECTORY -----
----- export total 0 SYSTEM_PRIVILEGE -----
----- export total 0 USER_ROLE_PRIVILEGE -----
export NO. 1 SYS_ROLE_PRIVILEGE : VTI
----- export total 1 SYS_ROLE_PRIVILEGE -----
----- export total 0 SYS_ROLE_PRIVILEGE -----
the privilege of the object at the export mode...
exporting NO. 1 SCHEMA : SYSDBA
start export schema[SYSDBA].....
----- export total 0 SEQUENCE -----
----- export total 0 VIEW -----
----- export total 0 TRIGGER -----
----- export total 0 COMMENT VIEW -----
----- export total 0 COMMENT COL -----
----- export total 0 PROCEDURE -----
----- export total 0 OPERATOR -----
----- export total 0 SYNONYM -----
----- export total 0 DBLINK -----
----- export total 0 TRIGGER -----
----- export total 0 PACKAGE -----
----- export total 0 PKG_BODY -----
----- export total 0 OBJECT of NO REFER OTHER CLASS -----
----- export total 0 OBJECT of REFER OTHER CLASS -----
----- export total 0 JCLASS -----
----- export total 0 CLASS_BODY -----
----- export total 0 DOMAIN -----
----- export total 0 PARTITION GROUP -----
the privilege of the object at the export mode...
---- [2023-11-25 15:29:20]export table:BAK_DMINI_231016 -----
export the privilege of the table...
table :BAK_DMINI_231016 export terminate, total export 1688 rows
---- [2023-11-25 15:29:20]export table:test -----
export the privilege of the table...
table :test export terminate, total export 1 rows
schema[SYSDBA] export terminate.....
successfully exported NO.1 SCHEMA : SYSDBA
export total 1 SCHEMA
all the export process spent total 0.103 s
terminate export success without warning
[dmdba@localhost dmexp]$ /dmdb8/dmdbms/bin/disql SYSDBA:5237
password:
Server[LOCALHOST:5237]:mode is normal, state is open
login used time : 2.634(ms)
disql V8
SQL> select * from test;
LINEID id
1 1
used time: 1.166(ms). Execute id is 1400.
日志有显示导出test表