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

OracleµÄ¾Û´Ø±í

Ë÷Òý¾Û´Ø±í
create cluster emp_dept_cluster
(deptno number(2)) size 1024;
size 1024 ±íʾÿ¸ö¾Û´Ø¼üÖµ¹ØÁª´óÔ¼1024×Ö½ÚµÄÊý¾Ý,
oracle»áÔÚÓÃÕâ¸öÊý¾Ý¿â¿éÉÏͨ¹ýsize¼ÆËã×î¶à¿ÉÒԷŶàÉÙ¸ö´Ø
Èç¹û¿éÊÇ8KB,ÄÇôÕâ¸ö¿éÉÏ×î¶à·Å7¸ö¾Û´Ø¼ü
Ïò¾Û´ØÖзÅÊý¾Ý֮ǰ,ÐèÒªÏȶԾ۴ؽ¨Á¢Ë÷Òý.
create index emp_dept_cluster_idx on cluster emp_dept_cluster;
¼ÓÔØµÄ·½Ê½Ó¦²ÊÓÃÒ»Ò»¶ÔÓ¦µÄ¹ØÏµ.¼ÓÔØÍêÖ÷±íÖ®ºóÔÙ¼ÓÔØ´Ó±í
ʲôÇé¿öϲ»ÄÜÓÃË÷Òý¾Û´Ø±í
1)Èç¹ûÔ¤Áϵ½¾Û´ØÖеıí»á´óÁ¿ÐÞ¸Ä,Ë÷Òý¾Û´Ø±í»á¶ÔDMLµÄÐÔÄܲúÉú¸ºÃæÓ°Ïì.
2)·Ç³£²»Êʺ϶Ե¥±íµÄÈ«±íɨÃè,ÒòΪֻÄÜÒýÆð¶ÔÆäËü±íµÄÈ«±íɨÃè
3)Ƶ·±¶Ô±í½øÐÐTRUNCATEºÍ¼ÓÔØ,ÒòΪ¾Û´ØÖеıíÊDz»ÄÜTRUNCATEµÄ
SQL> truncate table dept;
truncate table dept
               *
ERROR at line 1:
ORA-03292: Table to be truncated is part of a cluster
Èç¹ûÊý¾ÝÖ÷ÒªÓÃÀ´¶Á,²»ÔõôÐÞ¸Ä,²¢ÇÒÂß¼­ÉÏÓë¾Û´ØÁ¬½ÓÏëÊʺÏ,×îºÃʹÓÃË÷Òý¾Û´Ø±í
oracleÊý¾Ý×Öµä¾ÍÊÇÕâÑù×öµÄ
SQL> set autotrace traceonly statistics
SQL> select a.deptno,b.ename from dept_02 a,emp_02 b where a.deptno=b.deptno and
a.deptno='30';
6 rows selected.
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   MERGE JOIN
   2    1     INDEX (UNIQUE SCAN) OF 'dddd' (UNIQUE)
   3    1     FILTER
   4    3       TABLE ACCESS (FULL) OF 'EMP_02'
Statistics
----------------------------------------------------------
          0 recursive calls
          0 db block gets
          5 consistent gets
          0 physical reads
          0 red


Ïà¹ØÎĵµ£º

Oracle·¢²¼SunµÄ¸÷Ïî²úÆ·µÄδÀ´µÄFAQÁбí


Ô­·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......

OracleÊý¾ÝÎļþÇ¨ÒÆÖª¶àÉÙ£¿

±¾ÈËÒÔǰÕûÀíµÄÊý¾Ý¿âÎļþÇ¨ÒÆ¹ý³Ì£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú
1¡¢sqlplus "sys/sys@·þÎñÃû as sysdba"
 
2¡¢Ð޸ĿØÖÆÎļþ:
 
    alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
 'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\my ......

OracleÅÅÐòÒÔ¼°ÐòºÅµÄÊä³ö

   ÔÚÒ»°ãSelectÓï¾äÖÐÎÒÃÇͨ¹ýOrder by ...Asc/DescÀ´½øÐÐÅÅÐò¡£µ«ÊÇÕâÖÖÅÅÐò·½Ê½ÔÚÊä³öʱ£¬²»°üº¬ÅÅÐòºóµÄÐòºÅÐÅÏ¢¡£
   ÏÖÔÚ½éÉÜÒ»ÏÂOracleÖпÉÒÔÓÃÓÚÅÅÐòÊä³öµÄ·½·¨¡£
   1. RANK ( ) OVER ( [query_partition_clause] order_by_clause )
   RANK ( ) OVER ( [query_p ......

ÔÚOracleÊý¾Ý¿â´´½¨½Å±¾ÖÐÈçºÎ³õʼ»¯Ä³Ð©±í

Sample
±í¿Õ¼ä£ºIMPTEMP
±í£ºRoles ¡¢Users
ͨ¹ýPL/SQLµ¼³öµÄÊý¾Ý¿â½Å±¾
-----------------------------------------------------
-- Export file for user IMPTEMP                    --
-- Created by Administ ......

µ±ORACLE¹éµµÈÕÖ¾ÂúºóÈçºÎÕýȷɾ³ý¹éµµÈÕÖ¾

µ±ORACLE ¹éµµÈÕÖ¾ÂúÁ˺󣬽«ÎÞ·¨Õý³£µÇÈëORACLE£¬ÐèҪɾ³ýÒ»²¿·Ö¹éµµÈÕÖ¾²ÅÄÜÕý³£µÇÈëORACLE¡£
Ò»¡¢Ê×ÏÈɾ³ý¹éµµÈÕÖ¾ÎïÀíÎļþ£¬¹éµµÈÕÖ¾Ò»°ã¶¼ÊÇλÓÚarchiveĿ¼Ï£¬AIXϵͳÏÂÎļþ¸ñʽΪ“1_17884_667758186.dbf”£¬½¨Òé²Ù×÷ǰÏȶÔÊý¾Ý¿â½øÐб¸·Ý£¬É¾³ýʱÖÁÉÙ±£Áô×î½ü¼¸ÌìµÄÈÕÖ¾ÓÃÓÚÊý¾Ý¿â»Ö¸´¡£
¶þ¡¢°Ñ¹éµµÈÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ