Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

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

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

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

pl/sql - Oracle / ¿ª·¢

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

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

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ