ORACLE Êý¾Ý¿â¶ÔÏó
ORACLE Êý¾Ý¿â¶ÔÏó
——Ë÷Òý
q Ë÷ÒýÊÇÓë±íÏà¹ØµÄÒ»¸ö¿ÉÑ¡½á¹¹
q ÓÃÒÔÌá¸ß SQL Óï¾äÖ´ÐеÄÐÔÄÜ
q ¼õÉÙ´ÅÅÌI/O
q ʹÓà CREATE INDEX Óï¾ä´´½¨Ë÷Òý
q ÔÚÂß¼ÉϺÍÎïÀíÉ϶¼¶ÀÁ¢ÓÚ±íµÄÊý¾Ý
q Oracle ×Ô¶¯Î¬»¤Ë÷Òý
Ë÷ÒýµÄÄ¿±ê£ºÌá¸ß²éѯÐÔÄÜ
Ë÷Òý¶ÔÔöɾ¸Ä²éµÄÓ°Ïì
SQLÓï¾ä
¶ÔÐÔÄܵÄÓ°Ïì
SELECT
²éѯÐÔÄÜÌá¸ß
UPDATE
¸üÐÂɾ³ýʱÐèÒªÏȲéѯ£¬´Ó´Ë½Ç¶ÈÐÔÄÜÌá¸ß
¸üÐÂɾ³ýʱÒýÆðË÷ÒýÐ޸ģ¬´Ó´Ë½Ç¶ÈÐÔÄÜϽµ
DELETE
INSERT
Ôö¼ÓÒýÆðË÷Òý¸Ä±ä£¬Ë÷Òý¶ÔÆä¸ºÃæÓ°Ïì¸ü´ó£¬ÐÔÄÜϽµ
ʲôʱºò½¨Á¢Ë÷Òý£¿
1. ÐèҪƵ·±²éѯµÄÊý¾Ý
2. Êý¾ÝÁ¿½Ï¶à
3. ¸ÃÁв»»áƵ·± update/insert/delete
4. ÔÚ where/order by/group by ×Ö¾äÖгöÏÖµÄÁÐ
5. Ôڸ߻ùÊýÁÐÉϽ¨Á¢Ë÷Òý£¨Öظ´Êý¾Ý²»¶à£©
empno
ename
sal
1
HUANGPei
1000
1
HUANGPei
1000
3
HUANGPei
1000
4
HUANGPei
1000
empno
ename
sal
1
HUANGPei
1000
1
HUANGPei
1000
1
HUANGPei
1000
1
HUANGPei
1000
»ùÊý£º3/4
»ùÊý£º1/4
Ë÷ÒýµÄÀàÐÍ
ΨһË÷Òý
λͼË÷Òý
×éºÏË÷Òý
»ùÓÚº¯ÊýµÄË÷Òý
·´Ïò¼üË÷Òý
´´½¨±ê×¼Ë÷Òý
CREATE INDEX item_index ON itemfile (itemcode)
TABLESPACE index_tbs;
ÖØ½¨Ë÷Òý
ALTER INDEX item_index REBUILD;
ɾ³ýË÷Òý
DROP INDEX item_index;
ΨһË÷Òý
q ΨһË÷ÒýÈ·±£ÔÚ¶¨ÒåË÷ÒýµÄÁÐÖÐûÓÐÖØ¸´Öµ
q Oracle ×Ô¶¯ÔÚ±íµÄÖ÷¼üÁÐÉÏ´´½¨Î¨Ò»Ë÷Òý
q ʹÓÃCREATE UNIQUE INDEXÓï¾ä´´½¨Î¨Ò»Ë÷Òý
CREATE UNIQUE INDEX item_index
ON itemfile (itemcode);
×éºÏË÷Òý
q  
Ïà¹ØÎĵµ£º
ÓÃÃüÁîÐÐ(CMD)ÖÐÆô¶¯ºÍ¹Ø±ÕORACLE·þÎñ
¼àÌýÆô¶¯
lsnrctl start
¼àÌýÍ£Ö¹
lsnrctl stop
Æô¶¯Oracle
net start oracleservicesid
Í£Ö¹Oracle
net stop oracleservicesid
netÃüÁîÊÇwinϵͳÃüÁÆäËüµÄ·þÎñÆô¶¯ºÍÉÏÃæµÄÀàËÆ£¡
......
Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......
oracle startupʱ ±¨´íORA-00600: ÄÚ²¿´íÎó´úÂ룬²ÎÊý: [kcratr1_lostwrt], [], [], [], [], [], [], []
ÔÒò¿ÉÄÜÊÇ·Ç·¨¹Ø»ú»òµôµçÔì³É,ÒÔÏÂÊdzöÏÖµÄÎÊÌâ¼°½â¾ö·½·¨:
C:\Documents and Settings\Administrator>sqlplus
ÇëÊäÈëÓû§Ãû: /as sysdba
SQL> startup
ORA-01081: ÎÞ·¨Æô¶¯ÒÑÔÚÔËÐÐµÄ ORACLE ......
http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......
×Ô¼ºÕûÀíÁËÏÂOracleµÄÊý¾Ý¿â±¸·Ý·½°¸,ÓùýÀ䱸·Ý¡£ÆäËûûÓвâÊÔ¹ý
Ò»¡¢ µ¼³ö/µ¼Èë(Export/Import)
¡¡¡¡ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿â
ÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½Oracle
Êý¾Ý¿âÖÐÈ¥¡£
¡¡¡¡1¡¢ ¼òµ¥µ¼³öÊý¾Ý(Export)ºÍµ¼ÈëÊý¾Ý(Import):
¡¡¡¡OracleÖ§³ÖÈýÖÖ·½Ê½ÀàÐ͵ÄÊä³ö£º
¡¡¡¡(1)¡¢±í·½Ê½(T·½ ......