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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
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 / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......