Oracle Rowid ½éÉÜ
Ò». ÀûÓÃrowidÀ´µÃµ½Ïà¹ØÐÅÏ¢
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> create table bl(id number);
±íÒÑ´´½¨¡£
SQL> insert into bl values(1);
ÒÑ´´½¨ 1 ÐС£
SQL> select owner,segment_name,file_id,RELATIVE_FNO,block_id from dba_extents wh
ere owner='SYS' and segment_name='BL';
OWNER SEGMENT_NA FILE_ID RELATIVE_FNO BLOCK_ID
----- ---------- ---------- ------------ ----------
SYS BL 1 1 62129
SQL> desc dbms_rowid.rowid_info
PACKAGE SYS.DBMS_ROWID
PROCEDURE ROWID_INFO
Argument Name Type In/Out
------------------------------ ----------------------- ------
ROWID_IN ROWID IN
ROWID_TYPE NUMBER OUT
OBJECT_NUMBER NUMBER
Ïà¹ØÎĵµ£º
´ó²¿·ÖµÄÆóÒµºÜÄÑÒ»ÏÂ×Ó¾ÍÕÒµ½Ò»¸öÈ«·½Î»µÄOracle DBA£¨µ±È»Ò²ÊÇÓпÉÄÜ£¬Ö»²»¹ý£¬Õâ»áÓкܴóµÄÔËÆø³É·Ý£©£¬Õâ´ú±íÆóÒµÔÚÑ¡ÔñOracle DBAµÄʱºò£¬ÊƱØÒª¶Ô¸ºÔð¸ÃְλµÄDBAµÄÖ°ÄÜÓÐËùÈ¡Éá¡£ÎÒͨ³£»á½¨ÒéÎҵĿͻ§£¬ÔÚѰÕÒOracle DBAʱ£¬µÃÏÈÈ·ÈÏ£¬ÆóÒµÐèÒªÕâÒ»¸ö½ÇÉ«À´Æä´¦ÀíʲôÎÊÌ⣿
¡¡¡¡´ó²¿·ÝµÄÆóÒµ¶ÔOracle DBAµÄÐèÇó£¬Ò ......
×òÌìÔÚÕûÀíÎļþ¼ÐµÄʱºò²»Ð¡ÐĽ«Ò»¸ödbfÊý¾ÝÎļþÒÆ¶¯ÁË£¬½ñÌìµÇ¼plsqlʱȴ·¢ÏÖÌáʾora-01033£ºoracle initialization or shutdown in progressµÄ´íÎ󣬿ªÊ¼ÒÔsqlnet.oraµÄÎļþÅäÖÃÎļþ£¬µ«ÊǸÄÀ´¸ÄÈ¥»¹ÊǵǼ²»ÁË¡£×îºó°´ÕÕÍøÓѵÄÌáʾ½«sqlnet.oraÎļþÖеÄSQLNET.AUTHENTICATION_SERVICES= (NTS)¸Ä³ÉÁËSQLNET.AUTHENTICATI ......
SQL> with tt as
2 (
3 select 'haha' string from dual union
4 select '123' from dual union
5 select 'haha12' from dual union
6 select 'haha[]' from dual union
7 select '12@@' from dual union
8 select ......
Õâ¸öÖ÷ÌâÓë²¢·¢¿ØÖƵĹØÏµ·Ç³£½ôÃÜ£¬ÒòΪÕâÕýÊÇOracle²¢·¢¿ØÖÆ»úÖÆµÄ»ù´¡£¬Oracle²ÉÓÃÁËÒ»ÖÖ¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£²»¹ý£¬ÊµÖÊÉϽ²£¬OracleÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
q ¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽ ......
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾   ......