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;
»¹ÓÐÆäËûµÄ½â¾ö°ì·¨Âð
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇ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 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......