¼±£¡£¡£¡Ïò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: ´¥·¢Æ÷
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......