¼±£¡£¡£¡ÏòoracleÖвåÈëÊý¾Ýʱ³öÏÖ´íÎó
ÎÊÌâÃèÊö£º
ÎÒÔÚoracleÖн¨Á¢ÁËÁ½ÕÅ±í£¬t_terminal ºÍt_layout ,¹ØÏµÊÇÒ»¶Ô¶à£¬ÎÒÏòÒ»µÄÕâ¶Ë£¨t_terminal£©²åÈëÊý¾ÝÕý³££¬µ«ÊÇÎÒÏò¶àµÄÕâ¶Ë£¨t_layout£©²åÈëÊý¾Ý insert into t_layout values(1,'²¼¾Ö1',1,'bujuyi',0);³öÏÖÏÂÃæµÄ´íÎó
ORA-04098: ´¥·¢Æ÷ 'BULLETIN.TU_T_LAYOUT' ÎÞЧÇÒδͨ¹ýÖØÐÂÈ·ÈÏ
ORA-06512: ÔÚ"BULLETIN.TI_T_LAYOUT", line 9
ORA-04088: ´¥·¢Æ÷ 'BULLETIN.TI_T_LAYOUT' Ö´Ðйý³ÌÖгö
Íû¸ßÊÖÖ¸µã£¬Ð¡µÜ½«²»Ê¤¸Ð¼¤£¡QQ573486619£¬ÓÊÏ䣺hdc_love1@163.com
´¥·¢Æ÷'BULLETIN.TU_T_LAYOUT'ÓÐÎÊÌâ°¡
ÖØÐÂÖ´ÐÐһϴ´½¨´¥·¢Æ÷µÄ´úÂëÊÔÊÔ
http://blog.csdn.net/wengyupeng/archive/2008/09/24/2968580.aspx
Ã÷ÏÔ´¥·¢Æ÷ÓÐÎÊÌâ
¼ì²é¼ì²é
´¥·¢Æ÷´úÂëÌùÇÐÉÏÀ´¿´¿´
ÎÒÊÇÒ»¸öoracleÐÂÊÖ£¬ÎÒÔÚsystem Óû§Ï´´½¨ÁËÁËÒ»¸öÓû§
create user XXX identified by XXX
default tablespace users
temporary tablespace temp
quota 10M on users;
ÊÜȨÏÞ grant resource, connect to XXX
½ÓÏÂÀ´¾ÍÊÇÔÚXXXÓû§Ï½¨Á¢±íÁË£¬ÎÒ¶Ô´¥·¢Æ÷²»ÊǺÜÁ˽⣬Íû¸ßÊÖÖ¸µãÖ¸µã£¬Ð¡µÜºÜ¼±°¡£¡
Õâ¸ö¿Ï¶¨ÊÇÄã´¥·¢Æ÷µÄÎÊÌ⣬Äã¶Ô´¥·¢Æ÷²»ÊìϤ£¬Ôõôд³öÀ´µÄ°¡£¬£¬
Äã´¥·¢Æ÷ʵÏÖµÄÊÇ Ê²Ã´¹¦ÄÜ£¬Ìù³öÀ´¿´¿´
½¨Òé°Ñ´¥·¢Æ÷µÄ´úÂëÌù³öÀ´¡£
²»¿´¼û´úÂ룬û·¨¶¨Î»ÎÊÌâ¡£
ÎÒûÓÐдʲô´¥·¢Æ÷°¡£¬ÎÒÊÇÓÃERWin¹¤¾ßÁ¬½Óµ½oracleÊý¾Ý¿âÖУ¬°Ñ±í×Ô¶¯½¨Á¢ºÃµÄ£¬ÎÒÏÖÔÚ¾ÍÊÇÊÖ¶¯µÄ ²åÈëÊý¾Ý³öÏÖÏÂÃæ´íÎó£¬ÎÒ²»ÖªÊÇÔõô»ØÊ£¿
ORA-04098: ´¥·¢Æ÷
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......