Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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£¨µ±È»Ò²ÊÇÓпÉÄÜ£¬Ö»²»¹ý£¬Õâ»áÓкܴóµÄÔËÆø³É·Ý£©£¬Õâ´ú±íÆóÒµÔÚÑ¡ÔñOracle DBAµÄʱºò£¬ÊƱØÒª¶Ô¸ºÔð¸ÃְλµÄDBAµÄÖ°ÄÜÓÐËùÈ¡Éá¡£ÎÒͨ³£»á½¨ÒéÎҵĿͻ§£¬ÔÚѰÕÒOracle DBAʱ£¬µÃÏÈÈ·ÈÏ£¬ÆóÒµÐèÒªÕâÒ»¸ö½ÇÉ«À´Æä´¦ÀíʲôÎÊÌ⣿
¡¡¡¡´ó²¿·ÝµÄÆóÒµ¶ÔOracle DBAµÄÐèÇó£¬Ò ......

Oracle µÇ¼ÎÊÌâ

×òÌìÔÚÕûÀíÎļþ¼ÐµÄʱºò²»Ð¡ÐĽ«Ò»¸ödbfÊý¾ÝÎļþÒÆ¶¯ÁË£¬½ñÌìµÇ¼plsqlʱȴ·¢ÏÖÌáʾora-01033£ºoracle initialization or shutdown in progressµÄ´íÎ󣬿ªÊ¼ÒÔsqlnet.oraµÄÎļþÅäÖÃÎļþ£¬µ«ÊǸÄÀ´¸ÄÈ¥»¹ÊǵǼ²»ÁË¡£×îºó°´ÕÕÍøÓѵÄÌáʾ½«sqlnet.oraÎļþÖеÄSQLNET.AUTHENTICATION_SERVICES= (NTS)¸Ä³ÉÁËSQLNET.AUTHENTICATI ......

ORACLEÖÐËÑË÷×ÖĸÊý×Ö»ìºÏµÄ×Ö·û´®

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²¢·¢¿ØÖÆ»úÖÆµÄ»ù´¡£¬Oracle²ÉÓÃÁËÒ»ÖÖ¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£²»¹ý£¬ÊµÖÊÉϽ²£¬OracleÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
q  ¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽ ......

¹ØÓÚOracle SID´æÔÚ½â決°ì·¨

1¡¢   ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ    
Í£Ö¹ËùÓÐOracle·þÎñ¡£    
   
2¡¢   ¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle   -   OraHome81£­£¾Oracle   Installation   Products£­£¾   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ