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

oracleÂÒÂëÎÊÌâ

oracleÅ׳öµÄ´íÎóÏÖÔÚÊÇÂÒÂ루ÖÐÎÄÎÄ×Ö£©£¬ÈçºÎ°ÑÕâЩÖÐÎÄÎÄ×Ö±ä³É²»ÊÇÂÒÂ룬ÓõÄ×Ö·û¼¯ÊÇUTF8µÄ¡£

ÔÚÄÄÀﱨ´íÊÇÂÒÂëѽ¡£sqlplus»·¾³À»¹ÊdzÌÐòÀï¡£

ÔÚP/LSQLÀï̫̾£¿ºÃÏñ˵µÄ²»Ì«Ïêϸ°¡

ÔÚBATÖе÷ÓÃSQLÎļþµÄʱºò£¬Éú³ÉµÄLOGÎļþµ±ÖУ¬ÕâÀïÃæ¼ÙÈçÅ׳öORACLEµÄϵͳÒì³£µÄʱºò£¬ÖÐÎľͻáÂÒÂ룬Êý¾Ý¿â±àÂëÊÇUTF8µÄ¡£

Set ErrLogFile_TSQL= C:\_TSQL_ERR.LOG
sqlplus %UserId%/%PassWord%@%DatabaseName% @C:\WCL_ODR_PROC.sql  > %ErrLogFile_TSQL%




SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 25 13:39:02 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


???:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Session altered.

[SQLLDR_ERROR]PROPERTY ERROR.Error converting data type varchar to
datetime.[Receive_Date]

ÕâÀïÃæ¾ÍÊÇLOGÎļþÖеÄÄÚÈÝ£¬ ???:  ÕâЩÖÐÎľÍÊÇÂÒÂ룬²»ÖªµÀÈçºÎ½â¾ö£¬

ÎÒÏÖÔÚÊÇÕâÑù½â¾öµÄ£¬²»¹ý²»ÊÇÌ«ºÃ£¬¾ÍÊÇÔÚSQLÎļþÖе÷Óô洢¹ý³Ì֮ǰ£¬°Ñ ´òLOGµÄÐÅÏ¢µÄÖÐÎÄת»¯³ÉÁË Ó¢ÎÄ£¬¼ÓÁËÕâÑùµÄÒ»¾ä»°¡£
alter session set nls_language=american;

»¹ÓÐÆäËûµÄ½â¾ö°ì·¨Âð



Ïà¹ØÎÊ´ð£º

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

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

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

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

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

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

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ