Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

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

pl/sql - Oracle / ¿ª·¢

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

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

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 / ......

oralce µÄÒ»¸öSQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ 
¼ÙÉèÓÐÒ»ÕÅ±í£¬AºÍB×ֶζ¼ÊÇNUMBER£¬
A B
1 2
2 3
3 4

ÓÐÕâÑùһЩÊý¾Ý
ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä£¬²éѯ³öÕâÑùµÄÊý¾Ý
COLA COL1 COL3 COL2 COL1
4 4 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ