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

Oracle ¾Û¼¯

¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æð£¬²¢ÇÒËüÃǾ­³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾­³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æð£¬¾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI / O´ÎÊý£¬¸ÄÉÆÏµÍ³ÐÔÄÜ¡£
±íÖÐÏà¹ØµÄÁгÆÎª´Ø¼ü(cluster key)¡£´Ø¼üÓÃÒ»¸ö´ØË÷Òý(cluster index)À´½øÐÐË÷Òý£»¶ÔÓÚ´ØÖеĶà¸ö±í£¬´Ø¼üÖµÖ»´æ´¢Ò»´Î¡£ÔÚ°ÑÈκÎÐвåÈë´ØµÄ±íÖÐ֮ǰ£¬¶¼±ØÐëÏÈ´´½¨Ò»¸ö´ØË÷Òý¡£¶ÔÓÚ¾­³£Æµ·±Ò»Æð²éѯµÄ±í˵£¬Ê¹ÓôرȽϷ½±ã¡£ÔÚ´ØÖУ¬À´×Ô²»Í¬±íµÄÐд洢ÔÚͬһ¸ö¿éÖУ»Òò´Ëͬ½«±í·Ö¿ª´æ´¢Ïà±È£¬Á¬½ÓÕâЩ±íµÄ²éѯ¾Í¿ÉÄÜÖ´ÐиüÉÙµÄI / O¡£²»¹ý£¬Óë¶Ô·Ç¡£´Ø±íµÄÏàͬ²Ù×÷±È½Ï£¬´Ø±íµÄ²åÈë¡¢¸üкÍɾ³ýÐÔÄÜÒª²îºÜ¶à¡£Ôھ۴رí֮ǰ£¬ÒªÅжϹ²Í¬²éѯÕâЩ±íµÄƵÂÊ¡£Èç¹ûÕâЩ±í×ÜÊÇÒ»Æð²éѯ£¬¾ÍÒª¿¼ÂǰÑËüÃǺϲ¢³ÉÒ»¸ö±í¶ø²»ÊǾ۴ØÁ½¸ö±í¡£
Examples
1¡¢Creating a Cluster: Example
The following statement creates a cluster named personnel with the cluster key column department, a cluster size of 512 bytes, and storage parameter values:
CREATE CLUSTER personnel
   (department NUMBER(4))
;
2¡¢Cluster Keys: Example
The following statement creates the cluster index on the cluster key of personnel:
CREATE INDEX idx_personnel ON CLUSTER personnel;
After creating the cluster index, you can add tables to the index and perform DML operations on those tables.
3¡¢Adding Tables to a Cluster: Example
The following statements create some departmental tables from the sample hr.employees table and add them to the personnel cluster created in the earlier example:
CREATE TABLE dept_10
   CLUSTER personnel (department_id)
   AS SELECT * from employees WHERE department_id = 10;
CREATE TABLE dept_20
   CLUSTER personnel (department_id)
   AS SELECT * from employees WHERE department_id = 20;
 
 
 
ÊÔÑ飺´´½¨±ítesta¡¢testb¡¢²¢ÉèÖÃa01¡¢b01¹²Óþۼ¯testclu
     testa--a01
        


Ïà¹ØÎĵµ£º

ÈçºÎ½â³ýOracle ÕʺÅËø¶¨(the account is locked)

½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡   Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡    User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡  & ......

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

Oracle SQL TraceʹÓÃʵÀý

ΪÁËÑо¿Ò»ÏÂϵͳÔÚºǫ́¶¼¸ÉÁËʲô£¬µ±È»ÊÇÎÒÔÚ´úÂëÀïûÕÒµ½µÄÇé¿öÏ£¬Ñо¿ÁËÒ»ÏÂtrace£¬½á¹ûÓÐÒ»¶¨µÄ°ïÖú¡£oracleÖв»Ïñsql serverÖÐÄÇÑùÖ±½ÓÌṩͼÏñ»¯µÄ¹¤¾ß£¬ËùÒÔ»¹ÊǵÃ×Ô¼º¶¯ÊÖÀ´×ö£¬¹éÄÉÁËһϣ¬²½ÖèÈçÏ£º
²éѯsession£º
SQL> select sid, serial#, username from v$session where username='XXX';//ÕÒ³öÄãÒª¸ú ......

SQL ServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) v ......

sdeÓëoracleµÄ°æ±¾ÎÊÌâ

1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎʿռäÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.Ô­Òò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ