注册

dexp备份日志中为啥不显示test表?

董小姐 2023/11/25 519 1 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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.

回答 0
暂无回答
扫一扫
联系客服