ÈçºÎÔÚoracle²éѯºóÉú³ÉÎı¾Îļþ - Oracle / ¿ª·¢
Ò»¸ö²éѯ֮ºóÔõô¿ÉÒÔÉú³ÉÒ»¸öÎı¾Îļþ°¡? Ìý˵ÓÃshell½Å±¾¿ÉÒÔ×öµ½£¿ÄÇÒªÔõô×öÄØ£¿
spool D:\test.xls select name,value from table_name; spool off Êǽ«Êä³ö½á¹ûÊä³öΪÎı¾£¬»¹Êǽ«²éѯÓï¾äÊä³öΪÎı¾¡£ ÎÒÖ»ÏëÒª½á¹û ¿ÉÒÔspool³öÀ´»¹ÓÐÁÐÃûµÄÆäËû¶«Î÷ SQL code: ID PPP_BEGINTIME ROAMFLAG PAIDTYPE --------- ------------- -------- -------- 242489576 2010-04-19 23 2 1 242489577 2010-04-20 00 2 1 99 rows selected ÎÒÏëÒªµÄ½á¹ûÊÇÕâÑùµÄ SQL code: 242489576|2010-04-19|23|2|1 242489577|2010-04-20|00|2|1 End_rbody_64881934//--> ¸Ã»Ø¸´ÓÚ2010-04-22 12:58:08±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP ussl2alsk2 (ussl2alsk2) µÈ¡¡¼¶£º #7Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-22 12:29:05 End_rbody_64884134//--> ¸Ã»Ø¸´ÓÚ2010-04-22 13:21:22±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP hxj1225 µÈ¡¡¼¶£º #9Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-22 16:27:19 ÒýÓà һ¸ö²éѯ֮ºóÔõô¿ÉÒÔÉú³ÉÒ»¸öÎı¾Îļþ°¡? Ìý˵ÓÃshell½Å±¾
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......