·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí
ллÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓƵ£¬¸ú×ÅÊÓƵÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
2. ¹ÜÀí¿ÚÁ°ÑsysºÍsystem¸ü¸ÄÃÜÂ룬°Ñscott½âËø£¬ÉèÖÃÃÜÂë¡£
µã»÷½øÈ룺Net Configuration Assistant
ÅäÖüàÌýÆ÷¡£
ÒÔÉÏÅäÖÃÅäµÃºÜ¼òµ¥£¬Ëùµ¼ÖÂÏÂÃæµÄµÇ¼²âÊÔû³É¹¦¡£
ÓÃsql plusµÇ¼û³É¹¦£¨ÃüÁîÐеÄsql plusÄܵǣ¬µ«ÊÇwindowsµÄ²»Äܵǣ¬ÒòΪҪѡÔñÊý¾Ý¿âÃû£©£¬ÓÃpl/sql DeveloperµÇ¼Ҳû³É¹¦£¬È´·¢ÏÖDeveloperÏÂÀ²Ëµ¥µÄEXTPROC_CONNECTION_DATAÄÜÁ¬½ÓÉÏÊý¾Ý¿â¡£¶øÎÒÉ趨µÄÊý¾Ý¿âÊÇKIB¡£
×îºóµã»÷Net Manager£¬°Ñ·þÎñºÍ¼àÌýÖØÐÂÅäÖÃÁËÒ»±é£¬ÖÕÓÚÄÜÔÚsql plusºÍpl/sql DeveloperÉϵǼÁË¡£
ºóÀ´ÏëÁËһϣ¬ManagerºÍAssistantÄĸöµÄ×÷Óøü´óÄØ£¿
¸½ÉÏÅäÖúóµÄͼ£º
³É¹¦ÁË£¬Ö§³ÖÒ»ÏÂ
Îҳɹ¦°²×°¹ýÁË£¬·þÎñ¶ËºÍ¿Í»§¶Ë¶¼Óùý
End_rbody_65103577//-->
¸Ã»Ø¸´ÓÚ2010-04-30 16:04:56±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
bluemaths
(bluemaths)
µÈ¡¡¼¶£º
#4Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-30 16:52:51
Ö§³Ö¡£¡£¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔص½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,Ç°ÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......