²¿ÊðASP.NET·ÃÎÊoracleÌáʾÕÒ²»oracle¿Í»§¶Ë×é¼þÎÊÌâ
Ç°Á½Ì콫×Ô¼º±¾»úÆ÷ÖеÄASP.NETÓ¦Óò¿Êðµ½ÁË·þÎñÆ÷ÉÏ,½á¹û³öÏÖÁËЩÎÊÌâ.ÕÛÌÚÁËÁ½Ìì²Å¸ãÇå³þ.
Ê×ÏÈ·¢ÏÖ°²×°.NET3.5ʱºòÐèÒªÁ¬½ÓInternet,(Æäʵ°²×°°üÍêÕûµÄÀëÏß°²×°°ü)¶ø·þÎñÆ÷ÊÇÄÚ²¿ÍøÂçµÄ,ÿ°ì·¨Ö»ÄÜ°²×°Ò»¸öVS2008ÉÏÈ¥,Õæ²»Ã÷°×ΪºÎ°²×°VSʱºòdotNetFrameworkÓÖ²»ÐèÒªÁ¬½ÓInternetÁË.
ºóÀ´·¢ÏÖÔÚ±¾»úÆ÷ûÓÐÎÊÌâµÄÓ¦Óò¿ÉÏÈ¥ºóÓÖ²»ÄÜ·ÃÎÊÊý¾Ý¿âÁË(ʹÓÃOLEDB·½Ê½Á¬½ÓµÄORACLE),Ìáʾ±¾»úÆ÷δ°²×°oracle8.17ÒÔÉϵĿͻ§¶Ë,(ÒѾ°²×°ÁË,¶øÇÒÓÃsqlplus¿ÉÒÔ·ÃÎÊ)¿ªÊ¼ÒÔΪÊÇoralce°²×°³öÁËÎÊÌâÓÖ°²×°ÁËoracle9.2¿Í»§¶ËÒ²Ò»Ñù,ºóÀ´google²ÅÖªµÀÊÇNTFSÎļþϵͳ°²È«ÎÊÌâ,½â¾ö·½·¨£º ÔÚoracle/binĿ¼£¬¼ÓÈë¸øÒÔÏÂÓû§/×é,ÊÚÍêȫȨÏÞ:
asp.net machine account
administrator
authenticated users
²¢ÇÒ½«Asp.net¼ÓÈëµ½administrator×飬ÔÙÖØÆô
ºóÓÖ³öÏÖ´íÎó,ÌáʾÎÞ·¨»ñÈ¡Oracle´íÎóÐÅÏ¢,googleÁËϲÅÖªµÀʹжÔØoralce8.17ûÓÐɾ³ý×¢²á±íÐÅÏ¢°²×°oracle9.2¾ÍÎÞ·¨Ð´×¢²á±íÁË.ËùÒÔжÔغóÐèÒªÊÖ¹¤ÇåÀí×¢²á±í,ºóÔÚ°²×°.
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
1 spool
spool d:\test\table.dat
select * from table_name;
spool off
2 sqlplus user/password@sid @test.sql > table.dat
test.sql
select * from table_name;
exit; ......
oracle Êý¾Ý¿âÁ¬½Ó¾ÍÏñÄãÔÚ³ÌÐòÖн¨Á¢Ò»¸öµ½Êý¾Ý¿âµÄÁ¬½ÓÒ»Ñù¡£
Èç¹ûÊý¾Ý¿â²»ÔÚ±¾µØÖ÷»ú,±ØÐëÔÚ$ORACLE_HOME/network/admin/tnsnames.oraÖÐÅäÖÃÏàÓ¦µÄtns£¬È»ºó³ÌÐò²ÅÄÜͨ¹ýÅäÖúõÄtns·ÃÎÊÊý¾Ý¿â£¬µ«ÊÇjavaͨ¹ýthin·½Ê½·ÃÎÊoracleÀýÍ⣬¿ÉÒÔ²ÉÓÃÔÚ±¾µØÅäÖúõÄtns±ðÃû£¬Ò²¿ÉÒÔ²ÉÓÃtnsÈ«½âÎöÃû£¬²ÉÓñðÃûµÈºÅºóµÄÈ« ......
alter system kill session '²é³öµÄsid,²é³öµÄserial#';
ͨ過數據×ÖµäV$SESSION與V$LOCK來瞭½âÕýÔڵȴý鎖資Ô´µÄÓÃ戶
select a.username,a.sid,a.serial#,b.id1 from v$session a ,v$lock b
Where a.lockwait ......
alter table t_att_over_haul_safe_pres add c clob;
update t_att_over_haul_safe_pres set c=prt_precautions;
alter table t_att_over_haul_safe_p ......