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

oracleÖÐÖ±½ÓÐ޸ıíÁеÄÃû³ÆºÍ˳Ðò

µ¼ÈëÊý¾ÝµÃʱºò£¬Óöµ½Ò»¸öÎÊÌ⣬Ïë°ÑÁÐÃû˳Ðò¸Ä±äһϡ£ÔÚÍøÉÏËÑË÷µ½ÕâÆªÎÄÕ£¬Ã»È¥ÊÔÑé¡£ÌùÉÏÀ´£¬ÒÔºóÓлú»áÊÔÑéÏ¡£
£¨http://www.im80hou.com/html/oracle/2009/0710/712.html£©
 
°´ÕÕ¹ØÏµÊý¾Ý¿âµÄÀíÂÛ£¬ÐÐÓëÁж¼ÊÇÎÞÐòµÄ£¬µ«ÔÚʵ¼ÊÓ¦ÓÃÖÐÓÐʱÐèҪȷ¶¨ÁеÄ˳Ðò¡£µ«ÔÚOracleÖУ¬Ò»µ©±í¶¨ÒåºÃ£¬ÔÙÏëÐÞ¸ÄÁеÄ˳Ðò¿É²»Ì«ÈÝÒ×
¡¡¡¡
1£®ÒÔinternalÓû§ÃûµÇ¼OracleÊý¾Ý¿â£¬²¢´´½¨Ò»²âÊÔ±í¡£
SQL>CREATE TABLE SCOTT.TEST AS SELECT EMPNO,
            ENAME from SCOTT.EMP;
            SQL>DESC SCOTT.TEST
            Name Type Nullable Default Comments
            ------- ------------ -------
            EMPNO NUMBER(4) Y
            ENAME VARCHAR2(10) Y
ÏÂÃæÎÒÃÇÒª°ÑSCOTT.TEST±íÖÐEMPNOºÍENAMEÁ½Áе÷»»Ë³Ðò£¬²¢°ÑENAMEÁиüÃûΪEMP_NAME£¬EMPNO¸ÄΪEMP_NO¡£
2£®²éѯ±íÖÐÁеÄʵ¼Ê´æ´¢Î»Öûò±í¡£
SQL>SET LONG 9999£¬ÓÉÓÚTEXTÁÐÊÇLONGÀàÐÍ£¬Ö»ÓГSET”Ö®ºó²ÅÄÜÍêÈ«ÏÔʾ¡£
SQL>SELECT TEXT from ALL_VIEWS WHERE VIEW_NAME = ‘USER_TAB_COLUMNS’;
Êý¾Ý×ÖµäÊÓͼUSER_TAB_COLUMNSÖд洢ÓбíÁе͍ÒåÐÅÏ¢£¬´Ó¸ÃÓï¾äµÄ²éѯ½á¹û¿ÉÒÔ¿´³ö£¬Áж¨ÒåÐÅÏ¢ÊÇ´æ´¢ÔÚ±íSYS.COL$Öе쬼´Èç¹ûÐ޸ıíÖÐÁе͍Ò壬Ӧ¸ÃÔÚSYS.COL$±íÖÐÐ޸ġ£
3£®´ÓÊý¾Ý×ÖµäÊÓͼALL_OBJECTSÖвéÕÒ¶ÔÏóSCOTT.TEST¶ÔÏóID¡£
SQL> SELECT * from ALL_OBJECTS WHERE OWNER =‘SCOTT’ AND OBJECT_NAME=‘TEST’;
4£®¸ù¾ÝSCOTT.TEST¶ÔÏóµÄID£¬´ÓSYS.COL$¼ìË÷³ö±íÖÐÁе͍ÒåÐÅÏ¢¡£
SQL> SELECT OBJ#,COL#,NAME from SYS.COL$ WHERE OBJ# =13888;
            OBJ# COL# NAME
            ---------- ---------- -------
            13888 1 EMPNO
&n


Ïà¹ØÎĵµ£º

ORACLE REDO ¡¶ÉîÈëdz³öORACLEµÚÁùÕ¡·

RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......

Oracle undo »Ø¹ö¶Î¹ÜÀí


ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1.  ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
      ¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
  http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2.  »Ø¹ö¶Î(»Ø¹ö ......

oracle ·ÖÎöº¯Êýover() £¨Ò»£©

 Ô­ÎĵØÖ·£ºhttp://blog.csdn.net/cnham/archive/2009/08/30/4500928.aspx
oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÍ¨¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ ......

oracleÊý¾Ý¿âѧϰ£¨ZT£©

 oracleµÄÌåϵ̫ÅÓ´óÁË£¬¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÄÑÃâ»áÓÐЩÎÞ´ÓÏÂÊֵĸоõ£¬Ê²Ã´¶¼Ïëѧ£¬½á¹ûʲô¶¼Ñ§²»ºÃ£¬ËùÒÔ°Ñѧϰ¾­Ñé¹²Ïíһϣ¬Ï£ÍûÈøոÕÈëÃŵÄÈ˶ÔoracleÓÐÒ»¸ö×ÜÌåµÄÈÏʶ£¬ÉÙ×ßһЩÍä·¡£ 
Ò»¡¢¶¨Î» 
oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracle ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ