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

oracleÓÐĬÈÏÊý¾Ý¿âô

sql serverÏÂÓÐÁù¸öĬÈϵÄÊý¾Ý¿â£¬ÄÇôoracleÊDz»ÊÇÒ²ÓÐĬÈϵÄÊý¾Ý¿âÄØ£¿ÎÒÃÇÔÚ°²×°oracleʱϵͳΪÎÒÃÇ´´½¨µÄÊý¾Ý¿âËãÊÇÊ²Ã´ÄØ£¿
oracleÏÂÓÐĬÈÏschema¡£Õâ¾ÍÊÇÎÒÃÇ˵£¬oracleÀïµÄschema¼´Îªsql serverÀïµÄÊý¾Ý¿â¸ÅÄî¡£

µäÐ͵ÄÊÇscott schema¡£¼´Ê¾ÀýÑù±¾schema£¨sql serverÀïµÄÑù±¾database£©¡£


sys,system,scott... ÕâЩ¾ÍµÈͬÓÚsql serverÖеÄĬÈÏÊý¾Ý¿â

·´¶Ô£¬ÕâЩ¶¼ÊÇͬһ¸öʵÀýÏÂÃæµÄÕʺţ¬ÕâµãÈç¹ûÒÔǰʹÓÃSQLSERVER£¬È»ºó¸Õת¹ýÀ´ORACLE¾Í»áÀí½â´íÎó£¡

Oracle½¨¿âµÄʱºò£¬ÓÐschema£¬µ«ÊÇûÓÐÄã˵µÄĬÈϵÄÊý¾Ý¿âÕâÑùµÄ¸ÅÄî¡£

OracleÀïschema´ÖÂԵؿÉÒÔÀí½âΪÓû§£¬schemaÃû³ÆÓëÓû§Ãû³ÆÊÇÏàͬµÄ£»
schemaÊÇÓû§ÏµÄËùÓжÔÏóµÄ¼¯ºÏ£¬Èç¹ûÓû§ÏÂûÓжÔÏó£¬Ôò²»»á´æ´¢schema£»
Ö»ÓÐÓû§Ï´æÔÚ¶ÔÏóÁË£¬¸ÃÓû§²Å¾ßÓÐschema¡£

sorry£¬ÉÏÊö¡°´æ´¢¡±Ó¦Îª¡°´æÔÚ¡±


Ïà¹ØÎÊ´ð£º

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

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

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

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

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ