ORACLEµÄËø»úÖÆ
ORACLEµÄËø»úÖÆ
×òÌìÈ¥Ò»¸ö¹«Ë¾ÃæÊÔ£¬Îʵ½OracleµÄ·âËø»úÖÆ£¬ºÇºÇ£¬ÀíÂÛÉϵÄÎÊÌâºÃ¾Ã¶¼Ã»ÓÐѧϰÁË£¬Êé±¾µÄ¶«Î÷Ò²²î²»¶à¶¼»¹¸øÁË´óѧµÄÀÏʦ¡£»ØÀ´·ÁËÒ»ÏÂÊé±¾£¬ÕÒµ½Á˹ØÓÚÕⲿ·Ö֪ʶµÄ˵Ã÷£¬Ìù³öÀ´¹©´óѧ²Î¿¼¡££¨ÏÖÔڵĹ«Ë¾£¬¶¼²»ÖªµÀËûÃÇÆðÕÐʲôÑùµÄÈË£¬±¾À´ÊÇӦƸÈí¼þ¿ª·¢µÄ£¬È´ÒòΪÎÒ˵»áOracle£¬È´ÎÊÎҺöàOracleÀíÂÛÉϵÄÖªµÀ£¬ÈçÉÏ£©£º
ÉèÁ¢·âËø»úÖÆÖ÷ÒªÊÇΪÁ˶Բ¢·¢²Ù×÷½øÐпØÖÆ£¬¶Ô¸ÉÈŽøÐзâËø£¬±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍ׼ȷÐÔ¡£OracleÊý¾Ý¿â·âËø·½Ê½ÓÐÈýÖÖ£º¹²Ïí·âËø£¬¶ÀÕ¼·âËø£¬¹²Ïí¸üзâËø
[b:8f4f63b9bb]·âËøÀàÐÍ[/b:8f4f63b9bb]
Oracle¡¡RDBMSµÄ·âËøÀàÐÍ¿É·ÖΪÈçÏÂÈýÀࣺ
£±¡¢ÄÚ²¿¼¶·âËø
ÄÚ²¿¼¶·âËøÊÇÓÃÓÚ±£»¤ORACLEÄÚ²¿½á¹¹£¬ÓÉϵͳÄÚ²¿ÊµÏÖ£¬Óû§²»ÄÜ·ÃÎÊ£¬Òò´ËÎÒÃDz»±Ø¶Ô´Ë×ö¹ý¶àµÄÁ˽⡣
£²¡¢DDL¼¶·âËø£¨×Öµä/Óï·¨·ÖÎö·âËø£©
DDL¼¶·âËøÒ²ÊÇÓÉORACLE¡¡RDBMSÀ´¿ØÖÆ£¬ËüÓÃÓÚ±£»¤Êý¾Ý×ÖµäºÍÊý¾Ý¶¨Òå¸Ä±äʱµÄÒ»ÖÂÐÔºÍÍêÕûÐÔ¡£ËüÊÇϵͳÔÚ¶ÔSQL¶¨ÒåÓï¾ä×÷Óï·¨·ÖÎöʱ×Ô¶¯µØ¼ÓËø£¬ÎÞÐèÓû§¸ÉÓè¡£×Öµä/Óï·¨·ÖÎö·âËø¹²·ÖÈýÀࣺ
£¨£±£©¡¢×Öµä²Ù×÷Ëø£ºÓÃÓÚ¶Ô×Öµä²Ù×÷ʱ£¬ËøסÊý¾Ý×ֵ䣬´Ë·âËøÊǶÀÕ¼µÄ£¬´Ó¶ø±£»¤ÈκÎÒ»¸öʱ¿Ì½öÄܶÔÒ»¸ö×Öµä²Ù×÷¡£
£¨£²£©¡¢×ֵ䶨ÒåËø£ºÓÃÓÚ·ÀÖ¹ÔÚ½øÐÐ×Öµä²Ù×÷ʱÓÖ½øÐÐÓï·¨·ÖÎö£¬ÕâÑù¿ÉÒÔ±ÜÃâÔÚ²éѯ×ÖµäµÄͬʱ¸Ä¶¯Ä³¸ö±íµÄ½á¹¹¡£
£¨£³£©¡¢±í¶¨ÒåËø£ºÓÃÓÚ¡¡Ò»¸öSQLÓï¾äÕýµ±·ÃÎÊij¸ö±íʱ£¬·ÀÖ¹×ÖµäÖÐÓë¸Ã±íÓйصÄÏîÄ¿±»Ð޸ġ£
£³¡¢DML¼¶·âËø
DML¼¶·âËøÓÃÓÚ¿ØÖƲ¢·¢ÊÂÎñÖеÄÊý¾Ý²Ù×Ý£¬±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍÍêÕûÐÔ£¬Æä·âËø¶ÔÏó¿ÉÒÔÊDZí»òÐС£
¶ÔÓû§µÄÊý¾Ý²Ù×Ý£¬Oracle¿ÉÒÔ×Ô¶¯Îª²Ù×ݵÄÊý¾Ý½øÐзâËø£¬µ«Èç¹ûÓвÙ×ÝÊÚȨ£¬ÔòΪÂú×ã²¢·¢²Ù×ݵÄÐèÒªÁíÍâʵʩ·âËø¡£DML·âËø¿ÉÓÉÒ»¸öÓû§½ø³ÌÒÔÏÔʽµÄ·½Ê½¼ÓËø£¬Ò²¿Éͨ¹ýijЩSQLÓï¾äÒþº¬·½Ê½ÊµÏÖ¡£
DMLËøÓÐÈçÏÂÈýÖÖ·âËø·½Ê½£º
£¨1£©¡¢¹²Ïí·âËø·½Ê½£¨SHAR
Ïà¹ØÎĵµ£º
http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜÄ©È«Ìì¿ªÆ ......
http://episode.javaeye.com/blog/183016
±í¿Õ¼ä£º
OracleµÄUNDOTBS01.DBFÎļþÌ«´óµÄ½â¾ö°ì·¨
1¡¢.½ûÖ¹undo tablespace×Ô¶¯Ôö³¤
alter database datafile 'full_path\undotbs01.dbf' autoextend off;
2.-- ´´½¨Ò»¸öеÄС ......
oracle±í¿Õ¼ä²Ù×÷Ïê½â
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M
UNIFORM SIZE 128k;
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒ ......
(Ò»)ʵÏÖ·ÖÒ³¼°ÐÔÄÜ
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐзҳµÄÔʼ²éѯÓï¾ä¡£ROWNUM & ......
OracleÌṩWrap¹¤¾ß£¬¿ÉÒÔÓÃÓÚ¼ÓÃÜÄãµÄPackageµÈ.
²»¹ýÐèҪעÒâµÄÊÇ£¬¼ÓÃܺóµÄ´úÂëÎÞ·¨½âÃÜ£¬ÄãÐèÒª±£¹ÜºÃÄãµÄÔ´´úÂë¡£
ÒÔÏÂÊǸöÀý×Ó:
1.Ô´´úÂë
create or replace function get_rowid
(l_rowid in varchar2)
return varchar2
is
ls_my_rowid varchar2(200);
rowid_type number;
ob ......