OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
OracleÁÙʱ±í ÓÅ»¯²éѯËÙ¶È
1¡¢Ç°ÑÔ
Ä¿Ç°ËùÓÐʹÓÃOracle×÷ΪÊý¾Ý¿âÖ§³Åƽ̨µÄÓ¦Ó㬴󲿷ÖÊý¾ÝÁ¿±È½ÏÅÓ´óµÄϵͳ£¬¼´±íµÄÊý¾ÝÁ¿Ò»°ãÇé¿ö϶¼ÊÇÔÚ°ÙÍò¼¶ÒÔÉϵÄÊý¾ÝÁ¿¡£
µ±È»ÔÚOracleÖд´½¨·ÖÇøÊÇÒ»ÖÖ²»´íµÄÑ¡Ôñ£¬µ«Êǵ±Äã·¢ÏÖÄãµÄÓ¦ÓÃÓжàÕűí¹ØÁªµÄʱºò£¬²¢ÇÒÕâЩ±í´ó²¿·Ö¶¼ÊDZȽÏÅӴ󣬶øÄã¹ØÁªµÄʱºò·¢ÏÖÆäÖеÄijһÕÅ»òÕßij¼¸Õűí¹ØÁªÖ®ºóµÃµ½µÄ½á¹û¼¯·Ç³£Ð¡²¢ÇÒ²éѯµÃµ½Õâ¸ö½á¹û¼¯µÄËٶȷdz£¿ì£¬ÄÇôÕâ¸öʱºòÎÒ¿¼ÂÇÔÚOracleÖд´½¨“ÁÙʱ±í”¡£
ÎÒ¶ÔÁÙʱ±íµÄÀí½â£ºÔÚOracleÖд´½¨Ò»ÕÅ±í£¬Õâ¸ö±í²»ÓÃÓÚÆäËûµÄʲô¹¦ÄÜ£¬Ö÷ÒªÓÃÓÚ×Ô¼ºµÄÈí¼þϵͳһЩÌØÓй¦ÄܲÅÓõģ¬¶øµ±ÄãÓÃÍêÖ®ºó±íÖеÄÊý¾Ý¾ÍûÓÃÁË¡£OracleµÄÁÙʱ±í´´½¨Ö®ºó»ù±¾²»Õ¼Óñí¿Õ¼ä£¬Èç¹ûÄãûÓÐÖ¸¶¨ÁÙʱ±í£¨°üÀ¨ÁÙʱ±íµÄË÷Òý£©´æ·ÅµÄ±í¿ÕµÄʱºò£¬Äã²åÈëµ½ÁÙʱ±íµÄÊý¾ÝÊÇ´æ·ÅÔÚORACLEϵͳµÄÁÙʱ±í¿Õ¼äÖУ¨TEMP£©¡£
2¡¢ÁÙʱ±íµÄ´´½¨
´´½¨OracleÁÙʱ±í£¬¿ÉÒÔÓÐÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£º»á»°¼¶µÄÁÙʱ±íºÍÊÂÎñ¼¶µÄÁÙʱ±í¡£
1£©»á»°¼¶µÄÁÙʱ±íÒòΪÕâÕâ¸öÁÙʱ±íÖеÄÊý¾ÝºÍÄãµÄµ±Ç°»á»°ÓйØϵ£¬µ±Ä㵱ǰSESSION²»Í˳öµÄÇé¿öÏ£¬ÁÙʱ±íÖеÄÊý¾Ý¾Í»¹´æÔÚ£¬¶øµ±ÄãÍ˳öµ±Ç°SESSIONµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý¾ÍÈ«²¿Ã»ÓÐÁË£¬µ±È»Õâ¸öʱºòÄãÈç¹ûÒÔÁíÍâÒ»¸öSESSIONµÇ½µÄʱºòÊÇ¿´²»µ½ÁíÍâÒ»¸öSESSIONÖвåÈëµ½ÁÙʱ±íÖеÄÊý¾ÝµÄ¡£¼´Á½¸ö²»Í¬µÄSESSIONËù²åÈëµÄÊý¾ÝÊÇ»¥²»Ïà¸ÉµÄ¡£µ±Ä³Ò»¸öSESSIONÍ˳öÖ®ºóÁÙʱ±íÖеÄÊý¾Ý¾Í±»½Ø¶Ï£¨truncate table£¬¼´Êý¾ÝÇå¿Õ£©ÁË¡£»á»°¼¶µÄÁÙʱ±í´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Preserve Rows£»¾ÙÀýcreate global temporary table Student(Stu_id Number(5),Class_id Number(5),Stu_Name Varchar2(8),Stu_Memo varchar2(200)) on Commit Preserve Rows ;
2£©ÊÂÎñ¼¶ÁÙʱ±íÊÇÖ¸¸ÃÁÙʱ±íÓëÊÂÎñÏà¹Ø£¬µ±½øÐÐÊÂÎñÌá½»»òÕßÊÂÎñ»Ø¹öµÄʱºò£¬ÁÙʱ±íÖеÄÊý¾Ý½«×ÔÐб»½Ø¶Ï£¬ÆäËûµÄÄÚÈݺͻỰ¼¶µÄÁÙʱ±íµÄÒ»Ö£¨°üÀ¨Í˳öSESSIONµÄʱºò£¬ÊÂÎñ¼¶µÄÁÙʱ±íÒ²»á±»×Ô¶¯½Ø¶Ï£©¡£ÊÂÎñ¼¶ÁÙʱ±íµÄ´´½¨·½·¨£ºCreate Global Temporary Table Table_Name(Col1 Type1,Col2 Type2...) On Commit Delete Rows£»¾ÙÀý£ºcreate global temporary table Classes(Class_id Number(5),Class_Name Varchar2(8),Clas
Ïà¹ØÎĵµ£º
ÔçÉÏÓû§·´Ó¦ÔÚ²Ù×÷ÓÃÓÑNCʱ±¨´í ORA-01653 £¬ÏêϸÐÅÏ¢£ºORA-01653: ±í NCV35.GL_DETAIL ÎÞ·¨Í¨¹ý 1024 (ÔÚ±í¿Õ¼ä NNC_DATA01 ÖÐ) À©Õ¹¡£
ÔÚÈÕÖ¾Îļþ F:\oracle\product\10.2.0\admin\CUTC\bdump\alert_cutc.logÖУ¬³öÏÖ
Thu Mar 04 10:59:21 2010
ORA-1653: unable to extend table NCV35.GL_DETAIL by 1024 in&nb ......
ÏȼÙÉèÓÐÕâôһ¸ö±í£º
create
table
S_Depart (
DepartId
INT
& ......
³£ÓõÄORACLE PL/SQL¹ÜÀíÃüÁî
ÊìϤORACLE¹ÜÀíµÄÒ»¶¨¶ÔÕâЩÃüÁî²»»áÄ°Éú£¬²»¹ý¶ÔÓÚÎÒÕâ¸ö¸Õ½Ó´¥ORACLE¹ÜÀíµÄÀ´Ëµ£¬»¹ÊÇÓбØÒª×öϼǼ£¬ÒÔ±ãËæʱ²é¿´¡£
Ò» µÇ¼SQLPLUS
sqlplusÓû§Ãû/ÃÜÂë@Êý¾Ý¿âʵÀýasµÇ¼½ÇÉ«;
&nbs ......
對Ò»個DBA»òÐèʹÓÃexp,impµÄÆÕͨÓÃ戶來說£¬ÔÚÎÒ們×öexpµÄ過³ÌÖпÉÄÜ經³£會Óöµ½EXP£00091 Exporting questionable statistics.這樣µÄEXPÐÅÏ¢£¬Æä實Ëü¾ÍÊÇexpµÄerror message£¬Ëü產ÉúµÄÔÒòÊÇÒò為ÎÒ們exp¹¤¾ßËùÔÚµÄ環¾³ ......
Òª½â¾öOracleµÄ¿Í»§¶ËÂÒÂëÎÊÌâ¹Ø¼üÊÇÒª°Ñ·þÎñÆ÷¶ËʹÓõÄ×Ö·û¼¯¸ú¿Í»§¶ËʹÓõÄ×Ö·û¼¯Í³Ò»ÆðÀ´¡£Oracle¿Í»§¶Ë£¨Sqlplus£©Í¨¹ýNLS_LANG»·¾³±äÁ¿À´È·¶¨¿Í»§¶ËʹÓõÄ×Ö·û¼¯¡£NLS_LANG
²ÎÊýÓÉÒÔϲ¿·Ö×é³É:
NLS_LANG
=<Language>_<Territory>.<Clients Characterset>
NLS_LANG
¸÷²¿·Öº¬ÒåÈçÏÂ:
LANGUAGEÖ ......