oracleÊý¾Ý¿â¡¢±í¿Õ¼ä
ÎÒÊǸöoracleµÄ³õѧÕß¡£ÒòΪÒÔǰÓõÄÊÇMySQLºÍmssql£¬ËùÒÔÔÚѧoracleµÄʱºòÓеãÎóÇø¡£Ï£Íû¸ßÊÖÃǶà°ï°ïæ¡£
1.ÎÒǰ¼¸ÌìÔÚÕâÀïÌá¹ýÎÊÌ⣬¾ÍÊÇoracleµÄÓû§ÊDz»ÊÇÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬»Ø´ðÊǿ϶¨µÄ£¬µ«ÊÇÎÒÔÚÍøÉϲ鵽µÄ½á¹ûȴ˵oracleµÄ±í¿Õ¼äÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬Õâµ½µ×ʲôÊÇÕýÈ·µÄ°¡£¿
2.ÎÒ¸Õµ½ÏÖÔڵĹ«Ë¾²»³¤Ê±¼ä£¬ÒòΪ¸Õ¸Õ½Ó´¥Oracle£¬ËùÒÔÏë×Ô¼ºÑо¿Ò»Ï£¬ÎÒÃǵÄOracleÔÚaixµÄϵͳÏ£¬oracleÀïÃæ»¹ÓÐÎÒÃÇÓõIJâÊԵĶ«Î÷£¬ÎÒÓÃselect name from v$database;ÏÔʾxyzsµÄÒ»¸öÊý¾Ý¿â¡£ÄÇôÕâ¸öÊý¾Ý¿âÊÇʲôÒâ˼£¿µÇ½Óû§µÄÓµÓдËÊý¾Ý¿âô£¿»¹ÊÇÕû¸öoracle¾ÍÕâÒ»¸ö¿â£¿
3.ÎÒÏëÒª×Ô¼ºÑо¿Ò»ÏÂoracle£¬ÓõľÍÊÇÎÒÃǹ«Ë¾µÄ»·¾³¡£ÎÒдÁËÒ»¶Î´úÂ룬ÏÖÔÚÐèÒª½¨Ò»¸öÊý¾Ý¿â£¨¾ÍÏñmssql£©µÄÄÇÑùµÄ¿â£¬ÍøÉÏÓÐÈ˸æËßÎÒ½¨Ò»¸öÓû§ÔÙ½¨Ò»¸ö±í¿Õ¼ä¾Í¿ÉÒÔÁË£¬µ«Èç¹ûÎÒ½¨ÁËÒÔºó»á²»»áÔÚxyzsÏÂÃæÄØ£¬¶ÔÎÒÃDzâÊÔµÄÊý¾Ý¿âÓÐûÓÐÓ°ÏìÄØ£¿±ðÈ˻ῴµ½Ã´£¿ÎÒ×Ô¼ºÒª×ö¸ötest¿âÁ¬½Ó×Ô¼ºµÄ³ÌÐòÓ¦¸ÃÔõô×öÄØ£¿ÖØÐ½¨¸ö¿â»¹Êǽ¨¸öÓû§ºÍ±í¿Õ¼ä¾Í¿ÉÒÔÁËÄØ£¿
Çëǰ±²ÃÇÖ¸µãһϡ£Ð»Ð»£¡
ºÃÏñÉÏ´ÎÓÐÈËÎʹýÁËÀàËÆµÄÎÊÌâ¡£ÏÂÃæÊÇÌû×ÓµÄÁ´½Ó£º
http://topic.csdn.net/u/20100329/11/ed383ba0-7ca3-4fd5-8b49-46150667b927.html
ÕâЩ¶¼ÊÇORACLEµÄ»ù±¾µÄ¶«Î÷£¬½¨ÒéÂ¥Ö÷ÏÈ¿´Ò»Ð©ORACLE»ù´¡·½ÃæµÄ×ÊÁÏ£¬Èç¹Ù·½Îĵµ¡£
ÕâЩ»ù´¡ÖªÊ¶lZ»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£
°¥¡¡ ¹Ø¼üÎÒÊÇ¿´²»¶®°¡£¬ÕâºÜÈÃÎÒÓôÃÆ¡£ÎÒѧµÄ¶«Î÷¶¼ÊÇ´Óʵ¼ù¹ýÀ´µÄ£¬Ö®ºó²Åż¶û¿´¿´ÊéѧϰһЩµ×²ãµÄ¶«Î÷¡£¹Ø¼ü¸Õ¿ªÊ¼Ì«·Ñʱ¼äÁË£¬¹¤×÷Ò
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......