AccessÊý¾Ý¿âͨ¹ýODBCµ¼³öµ½OracleµÄÁ½¸öСÎÊÌâ
Ò». Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØн¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ÍûÓÐÎÊÌâ¡£
¶þ. Ora-01401:²åÈëµÄÖµ¶ÔÓÚÁйý´ó
ͬÑùÊÇͨ¹ýODBCµ¼³öµ½OracleʱÅöµ½µÄÎÊÌ⣬ÕâÖ÷ÒªÊÇÒòΪAccessºÍOracle¶ÔÓÚ×ֶεij¤¶È¶¨Ò岻ͬ¡£Access¶¨ÒåµÄÊÇ×Ö·û³¤¶È£¬Oracle¶¨ÒåµÄÊÇ×Ö½Ú³¤¶È£¬Åöµ½ÓÐÖÐÎÄÕâЩ˫×Ö½ÚµÄ×Ö·ûµÄ×ֶξͻᷢÉúÉÏÃæµÄÎÊÌâ¡£Ö»Òª°ÑÕâЩ×ֶΰ´ÕÕ×Ö½Ú³¤¶ÈÉèÖþͿÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
½«BLOB±£´æΪ±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æΪµÄÎĵµµÄ·¾¶</param>
......
ÇëÎÊÏÂ,ÎÒɾ³ý±íµÄ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 ......
1.²é¿´ËùÓÐÓû§£º
select * from dba_users;
select * from all_users;
select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ(Ö±½Ó¸³Öµ¸øÓû§»ò½ÇÉ«µÄϵͳȨÏÞ)£º
select * from dba_sys_privs;
select * from user_sys_privs;
3.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óû§ÓµÓеĽÇÉ«)Ëù°üº¬µÄÈ ......
Ò»¡¢¶¨Î»
¡¡¡¡oracle·ÖÁ½´ó¿é£¬Ò»¿éÊÇ¿ª·¢£¬Ò»¿éÊǹÜÀí¡£¿ª·¢Ö÷ÒªÊÇдд´æ´¢¹ý³Ì¡¢´¥·¢Æ÷ʲôµÄ£¬»¹ÓоÍÊÇÓÃOracleµÄDevelop¹¤¾ß×öform¡£ÓеãÀàËÆÓÚ³ÌÐòÔ±£¬ÐèÒªÓнÏÇ¿µÄÂ߼˼άºÍ´´ÔìÄÜÁ¦£¬¸öÈ˾õµÃ»á±È½ÏÐÁ¿à£¬ÊÇÇà´º·¹J£»¹ÜÀíÔòÐèÒª¶ÔoracleÊý¾Ý¿âµÄÔÀíÓÐÉî¿ÌµÄÈÏʶ£¬ÓÐÈ«¾Ö²Ù×ݵÄÄÜÁ¦ºÍ½ôÃܵÄ˼ά£¬ÔðÈνϴó£¬ÒòΪһ ......