AccessÊý¾Ý¿âͨ¹ýODBCµ¼³öµ½OracleµÄÁ½¸öСÎÊÌâ
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ÍûÓÐÎÊÌâ¡£
¶þ. Ora-01401:²åÈëµÄÖµ¶ÔÓÚÁйý´ó
ͬÑùÊÇͨ¹ýODBCµ¼³öµ½OracleʱÅöµ½µÄÎÊÌ⣬ÕâÖ÷ÒªÊÇÒòΪAccessºÍOracle¶ÔÓÚ×ֶεij¤¶È¶¨Ò岻ͬ¡£Access¶¨ÒåµÄÊÇ×Ö·û³¤¶È£¬Oracle¶¨ÒåµÄÊÇ×Ö½Ú³¤¶È£¬Åöµ½ÓÐÖÐÎÄÕâЩ˫×Ö½ÚµÄ×Ö·ûµÄ×ֶξͻᷢÉúÉÏÃæµÄÎÊÌâ¡£Ö»Òª°ÑÕâЩ×ֶΰ´ÕÕ×Ö½Ú³¤¶ÈÉèÖþͿÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
½«BLOB±£´æÎª±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æÎªµÄÎĵµµÄ·¾¶</param>
......
Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§ ......
ÇëÎÊÏÂ,ÎÒɾ³ý±íµÄijЩÊý¾Ý,ÈçºÎ°ÑËüÉÁ»ØÀ´Ñ½? 20·ÖÖÓÄÚ²»¹ý¶Ô¸Ã±íÓɲåÈëÁËЩÊý¾Ý
¸ù¾ÝscnºÅÀ´²éѯ
select a, b, c, versions_xid, versions_starttime, versions_endtime,
versions_startscn,versions_endscn,versions_operation
from test versions between scn 339493 and 339635
¸ù¾Ýʱ¼äÒ²¿ÉÒÔ
from te ......
»·¾³£ºasp.net +oracle9+windows2003
ÔÚ±¾µØ²âÊÔÍøÕ¾ÍêȫûÓÐÎÊÌâ¡£µ«ÊÇÒ»ÉÏ´«µ½·þÎñÆ÷¾Í³öÎÊÌâÁË£¬Êý¾Ý¿âÎÞ·¨Á¬½Ó¡£ÓÉÓÚÔ¶³ÌûÓÐVS»·¾³£¬ËùÒÔÎÞ·¨µ÷ÊÔ¡£ÕæÊÇ·ÑÁËÅ£¾¢²ÅÕÒµ½½â¾ö·½°¸£º
Problem Description ------------------- When running an application that connects to Oracle and uses the Authenticated ......