ÔÚOracleÖд´½¨ÊÓͼ£¬ÌáʾÎÞȨÏÞ ORA
½ñÌìÔÚ¶Ô±í´´½¨ÊÓͼµÄʱºò£¬Óû§Ìáʾ ORA-01031Óû§È¨ÏÞ²»×ã
ʹÓÃsystemÓû§¶ÔÆä·ÖÅädbaµÈȨÏÞ£¬ÒÀÈ»ÎÞ·¨´´½¨ÊÓͼ¡£
¼ÌÐø¸³ÓèȨÏÞ
grant select any table to AAA;
ÊÚÓèÓû§Ñ¯ËùÓбíµÄȨÏÞ
grant select any dictionary to AAA;
ÔÙ´ÎÊÚÈ¡Óû§selectÈκÎ×ÖµäµÄȨÏÞ
ÎÊÌâ½â¾ö
£¡£¡£¡£¡£¡£¡£¡
Ïà¹ØÎĵµ£º
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Ca ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл ......
1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎÊ¿Õ¼äÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.ÔÒò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......
OracleÊý¾Ý¿âÔÚʹÓùý³ÌÖУ¬Ëæ×ÅÊý¾ÝµÄÔö¼ÓÊý¾Ý¿âÎļþÒ²Öð½¥Ôö¼Ó£¬ÔÚ´ïµ½Ò»¶¨´óСºóÓпÉÄÜ»áÔì³ÉÓ²Å̿ռ䲻×ã;ÄÇôÕâʱÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý¿âÎļþÒƶ¯µ½ÁíÒ»¸ö´óµÄÓ²ÅÌ·ÖÇøÖС£ÏÂÃæÎÒ¾ÍÒÔOracle for Windows°æ±¾ÖаÑCÅ̵ÄÊý¾Ý¿âÎļþÒƶ¯µ½DÅÌΪÀý½éÉÜOracleÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨ºÍ²½Öè¡£
¡¡¡¡1.ÔÚsqlplusÖÐÁ¬½Óµ½ÒªÒƶ¯ÎļþµÄOr ......
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊÇ
±íÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬Ôò
rowidÔÚ¸ÃÐ ......