|
【如内容违法或虚假，请联系上述邮件删除】[php]
SQL> create table logmnr2 as select * from v$logmnr_contents;
Table created.
Elapsed: 00:00:31.76
SQL> exec print_sql(\'select * from logmnr2 where rownum=1\');
SCN : 86941469
CSCN :
TIMESTAMP : 12-aug-2004 12:44:18
COMMIT_TIMESTAMP :
THREAD# : 1
LOG_ID : 22921
XIDUSN : 3
XIDSLT : 39
XIDSQN : 38832
PXIDUSN : 3
PXIDSLT : 39
PXIDSQN : 38832
RBASQN : 22921
RBABLK : 2
RBABYTE : 16
UBAFIL : 0
UBABLK : 0
UBAREC : 0
UBASQN : 0
ABS_FILE# : 1
REL_FILE# : 1
DATA_BLK# : 29459
DATA_OBJ# : 19820
DATA_OBJD# : 19820
SEG_OWNER :
SEG_NAME :
SEG_TYPE : 0
SEG_TYPE_NAME : UNSUPPORTED
TABLE_SPACE :
ROW_ID : AAAE1sAABAAAHMTAAA
SESSION# : 0
SERIAL# : 0
USERNAME :
SESSION_INFO :
TX_NAME :
ROLLBACK : 0
OPERATION : DIRECT INSERT
OPERATION_CODE : 1
SQL_REDO : insert into \"UNKNOWN\".\"OBJ# 19820\"(\"COL 1\",\"COL 2\",\"COL 3\",\"COL 4\",\"COL 5\",\"COL 6\",\"COL
7\",\"COL 8\",\"COL 9\",\"COL 10\",\"COL 11\",\"COL 12\",\"COL 13\",\"COL 14\",\"COL 15\",\"COL 16\",\"COL 17\",\"COL 18\",\"COL 19\",\"CO
SQL_UNDO : delete from \"UNKNOWN\".\"OBJ# 19820\" where \"COL 1\" = HEXTORAW(\'c4575c1c0d\') and \"COL 2\" IS
NULL and \"COL 3\" = HEXTORAW(\'7868080c0c3503\') and \"COL 4\" IS NULL and \"COL 5\" = HEXTORAW(\'c102\') and \"COL 6\" =
RS_ID : 0x005989.00000002.0010
SEQUENCE# : 0
SSN : 0
CSF : 0
INFO : Dictionary Mismatch
STATUS : 2
REDO_VALUE : 96E3A138
UNDO_VALUE : 96E3A144
SQL_COLUMN_TYPE :
SQL_COLUMN_NAME :
REDO_LENGTH : 0
REDO_OFFSET : 0
UNDO_LENGTH : 0
UNDO_OFFSET : 0
-----------------
PL/SQL procedure successfully completed.
Elapsed: 00:00:01.05
SQL> select file_id,tablespace_name from dba_data_files;
FILE_ID TABLESPACE_NAME
---------- ------------------------------
1 SYSTEM
14 rows selected.
Elapsed: 00:00:00.01
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
[uniread] Saved history (1278 lines)
[oracle@www1 sql]$ sql
[uniread] Loaded history (1278 lines)
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Aug 12 13:41:32 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> select object_name from dba_objects where object_id=19820;
no rows selected
--------------------------
[/php](关注老榕树网络旗下“网络思维”微信公众号:wlsw360 (每天都有好文章)
本帖如有虚假或违法，请联系邮箱删除，本社区删贴不收任何费用，欢迎举报。老榕树社区属老榕树网络旗下网站，旨在为老榕树用户提供创业咨询、网站建设技术交流、源码下载、提供各种实用工具。如有部分帖子涉及违法、虚假，请你第一时间与社区联系，把需要删除的社区链接提供给我们，我们核实之后，第一时间删除。邮箱：125175998@qq.com | 
发表于 2014-9-27 10:55:11
收藏
分享
淘帖