ϲ»¶oracleÕâÔò¹ã¸æ
ÔÁ´½Ó£ºhttp://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=7731619&src=6817982&Act=4&sckw=APACMK09050910MPP005.GCM.8074.110
ÄÜ·ñÔÚµÚһʱ¼ä
»ñµÃÐÂÕ½ÂԵķ´À¡Òâ¼û£¿
ÄÜ·ñͨ¹ý¹ÜÀíÄ£ÐÍ
À´Ô¤²âÒµÎñÊý¾Ý£¿
ÄÜ·ñ²»±ØÔÙÎÊ“ÄÜ·ñ”
¶øÊÇÖ±½Ó»Ø´ðÏÂÒ»²½ÈçºÎ£¿
Èç¹ûÄÜ×ßµ½ÕâÒ»²½£¬ËüµÄ¼ÛÖµ²ÅÕæÕý͹ÏÔ³öÀ´£¬ºÜÅ£×µÄÐû´«Óï
Ïà¹ØÎĵµ£º
ORACLE 10 ѧϰ±Ê¼Ç-µÚ3¿Î-ÃüÁî¡£
1.view ÏÞÖÆ
create or replace view my_view01
as select * from emp
with check option
/
2.synonym ͬÒå´Ê
create synonym dept for scott.dept;
select * from dept;
3.sysdba ¹«¹²
drop synonym dept;
create public synonym dept for scott.dept;
desc dba_synonyms
......
ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......
ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐǨÒƺÍÐÐÁ´½Ó.(ÎÒÔÏȱ»Õâ¸ö°ü¸øÆÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......
OracleµÄÔÚÏßÖض¨Òå±í¹¦ÄÜ
http://blog.itpub.net/post/468/12855
http://blog.itpub.net/post/468/12962
ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸ģ¬µ«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ ......