ORACLEÊý¾Ý×Öµä¼ò½é
ORACLEÖеÄÊý¾Ý×ÖµäÊÇʲô£¿ÓÐÊ²Ã´ÌØµãºÍ¹æÂÉ£¿
Êý¾Ý×Öµä¼Ç¼ÁËÊý¾Ý¿âµÄϵͳÐÅÏ¢£¬ËüÊÇÖ»¶Á±íºÍϵͳÊÓͼµÄ¼¯ºÏ¡£
Êý¾Ý×ÖµäµÄËùÓÐÕßÊÇSYSÓû§£¬Êý¾Ý×ֵ䶼±»´æ·ÅÔÚSYSTEM±í¿Õ¼ä£¬SYSÓû§µÄ·½°¸Ï¡£
Êý¾Ý×ÖµäÖ»ÔÊÐíSELECT²Ù×÷£¬Æäά»¤ºÍÐÞ¸ÄÈÎÎñÓÉÊý¾Ý¿â×Ô¶¯Íê³É¡£
µ±Óû§Ö´ÐÐCREATE¡¢ALTER¡¢DROP²Ù×÷ʱ£¬OracleÊý¾Ý¿â»áÔÚÏàÓ¦Êý¾Ý×ÖµäÉÏÖ´ÐÐINSERT¡¢UPDATE£¬
DELETE²Ù×÷¡£
ORACLEÖÐÊý¾Ý×ÖµäÓÐÈýÖÖÀàÐÍ£¬·Ö±ðΪUSER_XXX¡¢ALL_XXX¡¢DBA_XXX£¬ÆäÖÐUSER_XXX±íʾµ±Ç°
Óû§ËùÓµÓеĶÔÏó£¬ALL_XXX±íʾµ±Ç°Óû§ÓвÙ×÷ȨÏ޵ĶÔÏó£¬DBA_XXX±íʾÊý¾Ý¿âÖÐËùÓеĶÔÏó¡£±È
È磺²ÉÓÃSCOTTÓû§µÇ¼Êý¾Ý¿âÖ®ºóÖ´ÐÐÏÂÁÐÃüÁî¿ÉÒÔ¿´µ½ÓÐËĸö±í£º
SQL> select table_name from user_tables;
TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE
Ö´ÐÐÏÂÁÐÃüÁîʱ¿ÉÒÔ¿´¶à·Ç³£¶àµÄ±í£¬ÆäÖаüÀ¨SCOTTËùÓµÓеĺÍSCOTTÓÐȨÏÞ·ÃÎʵģº
SQL> select table_name from all_tables;
Ö´Ðнá¹û£¨ÂÔ£©
DBA_XXX±íʾÊý¾Ý¿âÖÐËùÓеĶÔÏ󣬰üÀ¨ÊôÓÚÓû§µÄ¡¢Óû§ÓÐȨÏÞ·ÃÎʵÄÒÔ¼°ÏµÍ³ÖеĶÔÏó¡£ÒòΪDBA_XXXÊÔͼ¿ÉÒԲ鿴ϵͳÖеÄÐÅÏ¢£¬ËùÒԺܶàDBA_XXXÊý¾Ý×Öµä¶ÔûÓÐÏàӦȨÏÞµÄÓû§ÆÁ±ÎÁË¡£±ÈÈçDBA_TABLES£¬SCOTTÓû§¾ÍûÓÐȨÏ޲鿴£¬¶øSYSTEM¡¢SYSÓû§¾ßÓв鿴¸ÃÊý¾Ý×ÖµäµÄȨÏÞ¡£Èç¹ûҪʹij¸öÓû§¾ßÓв鿴DBA_XXXµÄȨÏÞ£¬Ôò±ØÐë¸øËüÊÚÓèDBA¡¢SELECT_CATALOG_ROLE½ÇɫȨÏÞ¡£
ÕÆÎÕÕâ¸ö¹æÂɾͿÉÒԺܷ½±ãµÄʹÓÃÊý¾Ý×ÖµäÁË¡£
Ïà¹ØÎĵµ£º
¹Ù·½Îĵµ£ºhttp://tahiti.oracle.com/
metalink:http://metalink.oracle.com
itpub:www.itpub.com
TOM:asktom.oracle.com
oracle forum:http://forums.oracle.com/forums/main.jspa?categoryID=84
OTN:http://www.oracle.com/technology/index.html
www.oracle.com.cn
www.eygle.com
Oracle ERP
www.erp10 ......
×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data
and redo logs for the undo logs are generated. Data from the temporary table is automatically
dropped in the case of session termination, either when the user logs o ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê &n ......
t±íÖн«½üÓÐ1100ÍòÊý¾Ý£¬ºÜ¶àʱºò£¬ÎÒÃÇÒª½øÐÐ×Ö·û´®Æ¥Å䣬ÔÚSQLÓï¾äÖУ¬ÎÒÃÇͨ³£Ê¹ÓÃlikeÀ´´ïµ½ÎÒÃÇËÑË÷µÄÄ¿±ê¡£µ«¾¹ýʵ¼Ê²âÊÔ·¢
ÏÖ£¬likeµÄЧÂÊÓëinstrº¯Êý²î±ðÏ൱´ó¡£ÏÂÃæÊÇһЩ²âÊÔ½á¹û£º
SQL> set timing on
SQL> select count(*) from t where instr(title,’ÊÖ²á’)>0;
COUNT(*)
&mdash ......
ǰÁ½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉϰ²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃ֨װoracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉϰ²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂë¶¼×öÁ˸͝£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......