oracle ¾«¼ò¿Í»§¶Ë Óë ·þÎñÆ÷¶Ë °²×°
ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory¡£
°´ÕÕÍøÉÏÄÇ´ËÐÞ¸Äoracle_homeµÄ·½·¨¶¼²»¹ÜÓá£
ÓÚÊÇ°Ñ¿Í»§¶ËжÔØ£¬ÖØÆôºó·¢ÏÖoracle³¹µ×²»ÄÜÓã¬×¼±¸Ð¶ÔØʱ·¢ÏÖoracle ÌáʾûÓÐÒÑ°²×°µÄ²úÆ·¡£
´íÎóµÄ¸ùÔ´ÊÇÔÚ²»ÂÛÔÚ°²×°¾«¼ò¿Í»§¶Ë»¹ÊÇ·þÎñÆ÷¶Ëʱ¶¼»áÔÚ×¢²á±íÖÐÌí¼ÓһЩÐÅÏ¢£¬
1µ±ÏÈ°²×°¾«¼ò¿Í»§¶Ë¶ûºóÓÖ×°·þÎñÆ÷¶Ëʱ²»»áÓÐÎÊÌâ³öÏÖ£¬²»¹ý¾«¼ò¿Í»§¶Ë´ËʱÒѲ»ÔÙ¹ÜÓá£ËùÓеÄtnsname¶¼ÒÔ·þÎñÆ÷°²×°µÄ·¾¶ÎªÖ÷¡£
2µ«ÊÇ°Ñ˳Ðò·´¹ýÀ´¾Í»áÓÐ´í£¬ÌرðÊǵ±Õß²»ÔÚÏàͬµÄĿ¼ÏµÄʱºò£¨¾«¼ò¿Í»§¶ËÒ»°ã¶¼ÔÚϵͳÅ̸ùĿ¼ÏµÄoracleĿ¼ÖУ©¡£ÒòΪ´Ëʱע²á±íÐÅÏ¢ÒÑ·¢ÉúµÄ¸Ä±ä¡£HKEY_LOCAL_MANCHINE\SOFTWARE\ORACLE,µ±Äã°Ñ¾«¼ò¿Í»§¶ËжÔصÄʱºòÕâ¸öĿ¼Ïî»á±»É¾³ý¡£
2µÄ½â¾ö·½°¸£º Ö»Ðè°Ñ×¢²á±íÖÐÉÏÊöµÄÏà¹Ø±íÏî Ìí¼Ó»òÕßÐÞ¸ÄΪoracle·þÎñÆ÷¶ËµÄĿ¼¼´¿É¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸ģ¬²¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼ ......
參¿¼:http://blog.csdn.net/rainnyzhong/archive/2009/01/09/3740660.aspx
×÷ÕߣºRainny
ÈÕÆÚ£º2009-1-8
´´½¨²âÊÔ±í£º
create table test(c_id varchar2(20));
²åÈë²âÊÔÊý¾Ý£º
insert into test values ('1234');
insert into test values ('45678');
insert into test values ('-12 ......
ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter table tb_test modify permile number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set permile_temp=permile;
alter t ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......