Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±£¡£¡£¡Ïò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Êý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ