Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AccessÊý¾Ý¿âͨ¹ýODBCµ¼³öµ½OracleµÄÁ½¸öСÎÊÌâ

Ò».  Ora-24801:ÔÚOCI_lobº¯ÊýÖзǷ¨µÄ²ÎÊýÖµ
 
°ÑÒ»Õź¬ÓГ±¸×¢”×ֶεıíͨ¹ýODBCµ¼³öµ½OracleµÄʱºòÒ»Ö±³öÏÖÈçÉÏͼËùʾµÄÌáʾÐÅÏ¢¡£³¢ÊÔÈ¥µôÏà¹Ø×Ö¶ÎÖпոñ×Ö·û£¬È¥µô×Ö¶ÎΪ¿ÕµÄ¼Ç¼£¬»¹Êǵ¼³öʧ°Ü¡£×îºóżȻ·¢ÏÖ£¬ÖØÐ½¨Ò»ÕÅÏàͬ½á¹¹µÄ¿Õ±í£¬È»ºó¸´ÖÆÔ­±íµÄ¼Ç¼£¬ÔÙÕ³Ìùµ½Ð±íÖУ¬µ¼³öµ½Oracle¾ÍûÓÐÎÊÌâ¡£
¶þ.  Ora-01401:²åÈëµÄÖµ¶ÔÓÚÁйý´ó
 
ͬÑùÊÇͨ¹ýODBCµ¼³öµ½OracleʱÅöµ½µÄÎÊÌ⣬ÕâÖ÷ÒªÊÇÒòΪAccessºÍOracle¶ÔÓÚ×ֶεij¤¶È¶¨Ò岻ͬ¡£Access¶¨ÒåµÄÊÇ×Ö·û³¤¶È£¬Oracle¶¨ÒåµÄÊÇ×Ö½Ú³¤¶È£¬Åöµ½ÓÐÖÐÎÄÕâЩ˫×Ö½ÚµÄ×Ö·ûµÄ×ֶξͻᷢÉúÉÏÃæµÄÎÊÌâ¡£Ö»Òª°ÑÕâЩ×ֶΰ´ÕÕ×Ö½Ú³¤¶ÈÉèÖþͿÉÒÔÁË¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

¶ÔoracleÖеÄBLOBµÄ²Ù×÷(¶ÁÈ¡£¬Ð´Èë)

 ½«BLOB±£´æÎª±¾µØÎĵµ£º
/// <summary>
/// ¶Á³öBlob×Ö¶Î
/// </summary>
/// <param name="commandText">sqlÓï¾ä£¬Ö´Ðнá¹ûΪBLOBÊý¾Ý</param>
/// <param name="DocumentAddress">½«Òª°ÑBLOBÊý¾Ý±£´æÎªµÄÎĵµµÄ·¾¶</param>
......

oracleµÄTX lockÐÅÏ¢ÔÚÄÄÀ

ÎÒÃǶ¼ÖªµÀORACLE²»»á·¢ÉúËøÉý¼¶£¬Ëø¶ÔÓÚORACLEÀ´Ëµ²¢²»ÊÇϡȱ×ÊÔ´£¬ÎªÊ²Ã´DML lock¶ÔÓÚORACLEÀ´Ëµ²»ÊÇϡȱ×ÊÔ´£¬ÏÂÃæÀ´Ñ°ÕҴ𰸡£
SQL> select * from emp where sal>2999;
EMPNO ENAME      JOB         MGR HIREDATE     ......

oracle ¿ìËÙ»Ö¸´±íɾ³ýµÄijÐÐÊý¾Ý

ÇëÎÊÏÂ,ÎÒɾ³ý±íµÄ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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ