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

oracleÀïµÄ³£ÓÃÃüÁî

µÚËÄÕ£ºË÷Òý
1.creating function-based indexes
sql> create index summit.item_quantity on summit.item(quantity-quantity_shipped);
 
2.create a B-tree index
sql> create [unique] index index_name on table_name(column,.. asc/desc) tablespace
sql> tablespace_name [pctfree integer] [initrans integer] [maxtrans integer]
sql> [logging | nologging] [nosort] storage(initial 200k next 200k pctincrease 0
sql> maxextents 50);
 
3.pctfree(index)=(maximum number of rows-initial number of rows)*100/maximum number of rows
 
4.creating reverse key indexes
sql> create unique index xay_id on xay(a) reverse pctfree 30 storage(initial 200k
sql> next 200k pctincrease 0 maxextents 50) tablespace indx;
 
5.create bitmap index
sql> create bitmap index xay_id on xay(a) pctfree 30 storage( initial 200k next 200k
sql> pctincrease 0 maxextents 50) tablespace indx;
 
6.change storage parameter of index
sql> alter index xay_id storage (next 400k maxextents 100);
 
7.allocating index space
sql> alter index xay_id allocate extent(size 200k datafile 'c:/oracle/index.dbf');
 
8.alter index xay_id deallocate unused; 
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/semisweet/archive/2006/07/13/913741.aspx


Ïà¹ØÎĵµ£º

Oracle All And Any

ת£ºOracle All And Any
    ÕâÊÇÔÚOracleÖбȽÏÈÝÒ×±»ºöÊÓµÄÁ½¸öÌõ¼þº¯Êý£¬µ«ÕâÁ½¸öº¯ÊýÆäʵ¶Ô¼ò»¯SqlÓï¾äÊǷdz£ÖØÒªµÄ×÷Óõġ£
¡¡¡¡ÀýÈç
scott@eddev> select ename, sal  from emp  where sal > any (1600, 2999);
ENAME         &nb ......

oracle ´æ´¢¹ý³Ì¼òÊö

´æ´¢¹ý³Ì¾ÍÊÇ×÷Ϊ¿ÉÖ´ÐжÔÏó´æ·ÅÔÚÊý¾Ý¿âÖеÄÒ»¸ö»ò¶à¸öSQLÃüÁî¡£
       ¶¨Òå×ÜÊǺܳéÏó¡£´æ´¢¹ý³ÌÆäʵ¾ÍÊÇÄÜÍê³ÉÒ»¶¨²Ù×÷µÄÒ»×éSQLÓï¾ä£¬Ö»²»¹ýÕâ×éÓï¾äÊÇ·ÅÔÚÊý¾Ý¿âÖеÄ(ÕâÀïÎÒÃÇ̸ֻSQL Server)¡£Èç¹ûÎÒÃÇͨ¹ý´´
½¨´æ´¢¹ý³ÌÒÔ¼°ÔÚASPÖе÷Óô洢¹ý³Ì£¬¾Í¿ÉÒÔ±ÜÃ⽫SQLÓï¾äͬASP´úÂë»ìÔÓ ......

oracle scnÑо¿

ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹ØÏµ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......

OracleÖÐTO_DATE¸ñʽ

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê               ......

oracleÃüÁî ÊÕ²Ø

  oracleÃüÁî ÊÕ²Ø
1. ORACLEÊý¾Ý¿âÆô¶¯Óë¹Ø±Õ
1.1 ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â (ÊÖ¹¤)
1.1.1 sqlplusÁ¬½Ó
  #su - oracle
#sqlplus  /nolog
1.1.2 ´ò¿ªÊý¾Ý¿â
sql> connect sys/oracle as sysdba;
  sql> startup [nomount|mount]
µÈ´ýÊ®¼¸Ãë×óÓÒ£¬µ±¿´µ½
oracle instances started,
databa ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ