Oracle »ØÊÕÕ¾¹¦ÄÜ,³¹µ×ɾ³ý±í
ת×Ô£ºhttp://www.cnblogs.com/houxm/archive/2009/08/26/1554481.html
Ïê½â£ºhttp://sunwayle.blog.51cto.com/114995/102516
Oracle »ØÊÕÕ¾¹¦ÄÜ,³¹µ×ɾ³ý±í
Oracle 10g
ÖгöÏÖ±íÃû£ºBIN$2cMp4FjwQ2Cw3Lj+BxLYTw==$0
×î½ü·¢ÏÖOracleÖгöÏÖÁËÕâЩÆæ¹ÖµÄ±íÃû£¬ÉÏÍø²éÕÒºó·¢ÏÖÊÇoracle10gµÄ»ØÊÕÕ¾¹¦ÄÜ£¬²¢Ã»Óг¹µ×µÄɾ³ý±í£¬¶øÊǰѱí·ÅÈë»ØÊÕÕ¾£¬×îºó¾Í³öÏÖÁË
ÕâÑùÒ»¶ÑÆæ¹ÖµÄ±íÃû¡£¡£¡£¡£
Ò»¡¢Çå³ýµÄ·½·¨ÈçÏ£º
¡¡¡¡1¡¢purge table origenal_tableName;
purge index
origenal_indexName;
2¡¢PURGE recyclebin;
¶þ¡¢²éѯÀ¬»øÐÅÏ¢£¬¿ÉÒÔÓÃÈçÏÂSQLÓï¾ä£º
¡¡¡¡SELECT t.object_name,t.type
,t.original_name from user_recyclebin t;
Èý¡¢É¾³ýTable²»½øÈëRecycleµÄ·½·¨£º
¡¡¡¡drop table tableName purge;
Ïà¹ØÎĵµ£º
oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ
Ä¿Ç°£¬ÕýÔò±í´ïʽÒѾÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ Öظ´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Orac ......
ÔÚOracleµÄQuery RewriteÖÐÖ÷ÒªÓÐÈýµã, µÚÒ»ÊÇҪʹÓÃCBO; µÚ¶þÊÇÒªÉèÖÃquery rewrite enabled²ÎÊýΪTRUE; µÚÈýÊÇÒªÏÈÔñÉèÖÃquery rewrite integrity²ÎÊýµÄÖµ(stale_tolerated, trusted, enforced). ¶ÔÓÚµÚÒ»µã, ÎÒÃÇ×îºÃanalyzeÏà¹ØµÄ±í¼°Ë÷Òý¼°MV; ¶ÔÓÚµÚ¶þµã,Õâ¸ö²ÎÊýÖ»ÓÐÁ½¸öÖµ(true, false), ºÜ¼òµ ......
ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû
¼ÙÈçÒª°ÑÖ÷»úÃû¸ÄΪoratest¡£
$±íʾoracleÓû§²Ù×÷£»
#±íʾrootÓû§²Ù×÷¡£
DB£ºoracle10.2
OS£ºRHEL4.5
µÚÒ»²½£¬¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbshut
$ lsnrctl stop
µÚ¶þ²¿£º
# hostname oratest
µÚÈý²½£º
# vi /etc/sysconfig/network
¸ü¸Ähostname²ÎÊý¡£
µÚËIJ½ ......
ÏîÄ¿ÖÐÓÐһЩ±¨±í£¬±¾ÉíËٶȾͲ»Ì«¿ì£¬Óöµ½Êý¾ÝÁ¿´óµÄÇé¿ö£¬¸üÊÇÈÃÈË×¥¿ñ£¬Óû§Ò²Ìá³öÁ˱¨±íËÙ¶ÈÂýµÄÎÊÌ⣬ÓÚÊÇÏë×ÅÈçºÎʵÏÖ±¨±íµÄÊý¾ÝÒÀÀµ»º´æ£¬¼´½«±¨±íÊý¾Ý»º´æ£¬µ±Êý¾Ý·¢Éú¸Ä±äʱ£¬ÔÙÖØлñÈ¡Êý¾Ý¡£
×î¼òµ¥µÄ·½·¨£¬ÊÇÔÚÏÔʾ±¨±íµÄaspxÒ³ÃæµÚÒ»ÐмÓÉÏÐÎÈç<%@ OutputCache Duration="600" VaryByParam="some_par ......
ÓÐһЩûÓÐʹÓÃÊý¾Ý¿âÖмä¼þµÄÈí¼þ¿ÉÄÜ»áÅöµ½ÔÚ²»Í¬µÄÓ¦Óó¡¾°ÐèÒªÓò»Í¬µÄÊý¾Ý¿â£¬ÕâÑù¿ÉÄܾÍÐèÒª½«Êý¾Ý¿â´úÂë×öÒÆÖ²£¬ÎÒÕâÀïÕûÀíÁËһЩ´Óoracleµ½mysqlµÄÒÆÖ²¹ý³ÌÖеÄ×¢ÒâÊÂÏ
1¡£sequenceÉú³É
¿ÉÒÔÓÃÀàËƵĶ«Î÷À´×ö,ÈçÏ£º
create table myseq ( &nb ......