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

oracle 10°²×°µÄÎÊÌâ

³õѧoracle
ÇëÎÊϰ²×°oracleÊDz»ÊDZØÐëÔÚ´øÍøÂçÁ¬½ÓµÄµÄÌõ¼þϰ²×°£¿ËÞÉáûÁªÍø£¬Ã¿´Î°²×°¶¼µ½79%×óÓҾ͵¯³ö°²×°½áÊø£¬Ã»ÓÐconfiguration assistant ÅäÖùý³Ì£¬Í˳ö°²×°Ò²Ã»Óе¯³öÊý¾Ý¿âµÇ½½çÃæ¡£ ÔËÐÐSQL PLUS ÎÞ·¨µÇ½£ºÎÞ·¨½âÎöÖ¸¶¨×Ö·û
  Çë¸ßÈ˽âÊÍÏ····


²»ÐèÒªÁªÍø¼´¿É°²×°£¬¿ÉÒÔ¿´ÏÂÈÕÖ¾Îļþ

ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£

ÒýÓÃ
ºÃÏñÊÇÓÐÕâ¸öÎÊÌâ¡£ÎÒÒÔǰҲÓöµ½¹ý¡£×°¸övmÀ´×öʵÑéÓ´¡£

ÎÒ×öÌì×°Á˸ö ÐéÄâÍø¿¨£¬ÎÊÌâÒÀ¾É····

²»ÓÃÁªÍøÒ²¿ÉÒÔ°²×°µÄ

Èç¹ûûÓа²×°ÍêÈ«µÄ»°£¬¹À¼ÆÊǰ²×°ÎļþµÄÎÊÌâ¡£¡£¡£½¨ÒéÖØÐÂÏÂÔØÒ»¸ö°²×°ÎļþÀ´ÊÔÊÔ

¿ªÊ¼-->³ÌÐòÀïÓÐOracle - OraDbX_home1µÄ»°£¬ÊÖ¹¤°²×°Êý¾Ý¿âÊÔÊÔ

LZÇ뱨ÄãµÄϵͳ»·¾³£¬ºÍoracle¾ßÌå°æ±¾ºÅ

ÎÒн¨ÁËÒ»¸ö´¿×ÖĸÕË»§
°²×°ÁËÐéÄâÍø¿¨
È»ºóжװËùÓÐOracle²úÆ·

ɾ³ýHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ServicesÀïûÕÒµ½ORACLEÏà¹Ø
È»ºóÖØÆôɾ³ýC:\Oracle

ÔÙ°²×°  ¾Í³É¹¦ÁË···


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......

oracle Ö´ÐÐ˳Ðò - Oracle / »ù´¡ºÍ¹ÜÀí

SQL code:

declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ