28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü
28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄÜ°ÑÏÂÔصõ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11g Release 1 (11.1.0.6.0) for Linux x86”£¬°²×°°üÎļþÃûΪlinux_11gR1_database_1013.zip£¬ÒÔzip¸ñʽѹËõ£¬ÏÂÔغó°ÑÎļþ±£´æµ½/tmp/Ŀ¼Ï¡£
Ïà¹ØÎĵµ£º
參¿¼:http://blog.csdn.net/rainnyzhong/archive/2009/01/09/3740660.aspx
×÷ÕߣºRainny
ÈÕÆÚ£º2009-1-8
´´½¨²âÊÔ±í£º
create table test(c_id varchar2(20));
²åÈë²âÊÔÊý¾Ý£º
insert into test values ('1234');
insert into test values ('45678');
insert into test values ('-12 ......
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.²é¿´½ÇÉ«(Ö»Äܲ鿴µÇ½Óû§ÓµÓеĽÇÉ«)Ëù°üº¬µÄÈ ......
½ñÌìÓиö¹¦ÄÜÐèÒª¶ÔCLOB×ֶνøÐвÙ×÷£¬ÆÚ¼äÓöµ½¼¸¸öÎÊÌ⣬ÀÏÌì¾ì¹Ë£¬¶¼ËãÊǽâ¾öÁË£¬¼Çһϣ¬ÃâµÃÈÕºóÖص¸¸²ÕÞ¡£
´íÎóÒ»£º
ORA-22920: δËø¶¨º¬ÓÐ LOB ÖµµÄÐÐ
³öÏÖÕâ¸öÎÊÌâµÄÔÒò£¬ÊÇÓÉÓÚselect³öLOB×Ö¶Îʱδ¼Ó for update£¬ORACLE¹Ù·½Îĵµ¶Ô¸Ã´íÎóµÄ˵Ã÷£º
ÒýÓÃÎÄ×Ö´úÂë
ORA-22920 ro ......
»·¾³£ºasp.net +oracle9+windows2003
ÔÚ±¾µØ²âÊÔÍøÕ¾ÍêȫûÓÐÎÊÌâ¡£µ«ÊÇÒ»ÉÏ´«µ½·þÎñÆ÷¾Í³öÎÊÌâÁË£¬Êý¾Ý¿âÎÞ·¨Á¬½Ó¡£ÓÉÓÚÔ¶³ÌûÓÐVS»·¾³£¬ËùÒÔÎÞ·¨µ÷ÊÔ¡£ÕæÊÇ·ÑÁËÅ£¾¢²ÅÕÒµ½½â¾ö·½°¸£º
Problem Description ------------------- When running an application that connects to Oracle and uses the Authenticated ......