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

oracle ɾ³ý±í

ÔÚ´æ´¢¹ý³ÌÀïÔõôɾ³ý±í£¬ÎÒʹÓãº
drop table MV_AREA_TID_LOTTERY_DAY_TMP;
ÕâÓï¾ä£¬µ«±¨
Compilation errors for PACKAGE BODY OMAS.PKG_PROCIMPORTDATA

Error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following:

:= . ( @ % ; immediate
Line: 87
Text: execute drop table MV_AREA_TID_LOTTERY_DAY_TMP;



ÔõôÑùÔÚ´æ´¢¹ý³ÌÀïɾ³ýÒ»¸ö±í£¬³ýÁËʹÓÃexecute immediate 'drop table MV_AREA_TID_LOTTERY_day_TMP'; ûÆäËü°ì·¨ÁËÂð£¿
ʹÓÃexecute immediate 'drop table MV_AREA_TID_LOTTERY_day_TMP'ÓÐʲôÎÊÌâÂð£¿

Oracle 8i ¼°ÒÔÉϰ汾ÖУ¬»¹ÄÜÓà DBMS_UTILITY.EXEC_DDL_STATEMENT(ddl_sql_str) Ö´ÐÐ DDL Óï¾ä¡£
µ«ÊÇÎÞÂÛÄÄÖÖÇé¿ö£¬ÄãµÄPACKAGE BODY±àÒëδͨ¹ý£¬¸ù±¾ÎÞ·¨Ö´ÐС£Ê×ÏÈÐèҪͨ¹ý±àÒ룬ȻºóÔÙÖ´ÐС£¡£

ddlÔÚprocedureÖ»Äܶ¯Ì¬sql¡£

plsqlµÄ³ÌÐò¿é£¬±ÈÈçprocedureºÍtriggerÊDz»ÄܼÓÈëddlÓï¾äµÄ£¬Èç¹ûÓÐddlÓï¾ä£¬ÊÇÓбàÒë´íÎó¡£

µ«ÊÇoracleÌṩÁËexecute immediateÕâÑùµÄ¶¯Ì¬sqlµÄ¹¦ÄÜ¡£

ÓÃÁËexecute immediateÓï¾ä£¬Ôõô±£Ö¤Ö´ÐеÄ˳ÐòÄØ


ÒýÓÃ
ÒýÓÃÂ¥Ö÷ pdw2009 µÄ»Ø¸´:
ÔÚ´æ´¢¹ý³ÌÀïÔõôɾ³ý±í£¬ÎÒʹÓãº
drop  table  MV_AREA_TID_LOTTERY_DAY_TMP;
ÕâÓï¾ä£¬µ«±¨
Compilation errors for PACKAGE BODY OMAS.PKG_PROCIMPORTDATA

Error: PLS-00103: Encountered the symbol "DROP" when expecting one of the following:
     
       


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

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

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

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

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

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ