Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ѧºÃOracleÁùÌõ×ܽá

 
1¡¢Èç¹ûÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡£¬ÖªµÀSQLÊÇÔõô»ØÊ£¬¼´Ê¹Ð´²»³öÀ´¼òµ¥µÄSQL£¬µ«¿ÉÒÔ¿´¶¯ËüÃÇ£¬Äã¾Í¿ÉÒÔÌøµ½2¡£·ñÔòÇëÏÈ¿´Ò»ÏÂÊý¾Ý¿â»ù´¡ºÍSQLÓïÑÔ£¬²»ÐèÒªºÜÉ¸ü²»ÐèҪȥ¼ÇÒäÄÇЩ¸´ÔÓµÄSQLÃüÁÕâЩ¿ÉÒÔÁôÔÚÒÔºó±ßÓ¦Óñßѧϰ¡¢¼ÇÒä¡£
¡¡¡¡
¡¡¡¡2¡¢ÒªÏëѧºÃORACLE£¬Ê×ÏÈҪѧϰORACLEµÄÌåϵ½á¹¹£¬ÏÖÔÚÄã²»ÐèÒªÉîÈëÀ ......

Oracle ÒÆ¶¯Êý¾ÝÎļþµÄ²Ù×÷·½·¨


½«±í¿Õ¼äºÍÊý¾ÝÎļþ´ÓÒ»¸öλÖÃÒÆ¶¯µ½ÁíÒ»¸öλÖõIJÙ×÷·½·¨
Ò»£® OFFLINE
OFFLINE ·ÖΪALTER DATABASE Óë ALTER TABLESPACE OFFLINE£¬
ËûÃǵÄÇø±ð²Î¿´blog£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/29/4898800.aspx
°´Êý¾ÝÎļþÀ´£º
1.ÏȽ«ÏàÓ¦µÄÊý¾ÝÎļþ offl ......

oracle over()º¯Êý¼¼ÊõÏê½â

 Ô­ÎĵØÖ·£ºhttp://hi.baidu.com/zengjl/blog/item/c06c8edeb2c7e45cccbf1aca.html/cmtid/305a850ea57b09ec37d1226c
1.²éѯ±íÊý¾Ý
SQL> select deptno,ename,sal
   2   from emp
   3   order by deptno;
DEPTNO ENAME          SAL ......

oracleÆô¶¯¼àÌý³öÏÖTNS 12547´íÎó

ÏÖÏó£º
oracleÆô¶¯¼àÌý£¬±¨¸æÈçÏ´íÎó£º
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
Ô­Òò£º
lisenter.log ÎļþÌ«´óÁË,OracleÎÞ·¨¶ÔËü½øÐвÙ×÷ÁË£¬µ¼ÖÂlistenerÎÞ·¨Õý³£Æô¶¯¡£
listener.log ³¬¹ý2G¾Í»á³öÎÊÌâ
·½·¨£º
·¨1. ÒÆ³ýÔ­$ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ