ÓÃPowerDesingner°ÑoracleÖÐµÄ±íµ¼³Éerͼ
ͨ¹ýwindowsÊý¾ÝÔ´¹ÜÀí£¬½¨Á¢ODBCÊý¾ÝÔ´¡£
ÎÒµÄÊÇ»ùÓÚoracle10g¡£
´ò¿ªWindowsµÄ¿ØÖÆÃæ°å
´ò¿ª¹ÜÀí¹¤¾ß
´ò¿ªÊý¾ÝÔ´(ODBC)
Ñ¡ÔñÄãÒª²Ù×÷µÄÊý¾Ý¿âÀàÐÍ
1.ÎÒÑ¡ÔñµÄʱºò±¨Î´ÕÒµ½¿Í»§¶Ë×é¼þºÍһЩ¿Í»§¶ËÎļþ
2.¿Í»§¶ËÎÒÒÔ×°ÁË¡£
½â¾ö·½·¨£ºÕÒµ½oracle°²×°Ä¿Â¼ÏµÄBINĿ¼ÎÒµÄÊÇD:\oracle\BIN
°ÑÕâ¸ö¸´ÖƵ½»·¾³±äÁ¿pathϾͿÉÒÔÁË
ÊäÈëÊý¾Ý¿â²ÎÊý£¬²¢²âÊÔÁ¬½Ó
2> ͨ¹ýpowerDesignerʹÓÃODBCÊý¾ÝÔ´£¬½¨Á¢PowerDesignerµÄÊý¾ÝÔ´¡£
н¨ÎïÀíÄ£ÐÍ.
Ñ¡ÔñÊý¾Ý¿â(DataBase)---Á¬½Ó£¨Connect£©¡£
Ñ¡ÔñÒѾÅäÖúõÄODBCÊý¾ÝÔ´¡£
ÊäÈëµÇ¼Êý¾Ý¿âµÄ¡¾Óû§Ãû¡¿ºÍ¡¾ÃÜÂë¡¿¡£
2> ʹÓÃPowerDesigner½øÐÐÄæÏò¹¤³Ì¡£
Ñ¡Ôñ DataBase----Reverse Engineer Database¡£
²»Í¬µÄ°æ±¾Ãû×ÖÓеãÇø±ð¡£
ʹÓÃÒѾÅäÖúõÄÊý¾ÝÔ´¡£
Ñ¡ÔñÄã¸ÐÐËȤµÄÄÚÈÝ¡£
Éú³ÉÎïÀíÄ£ÐÍ¡£
ÎÒÃÇÉÔ×öµÈ´ý£¬ÎÒ³öÏÖÁËÎÒÃÇÐèÒªµÄÊý¾ÝÄ£ÐÍ¡£ÈçÏÂͼ£º
·Å´óºó
µ½ÕâÀÎÒÃǵÄÄæÏò¹¤³Ì£¬¾ÍÍê³ÉÁË¡£
Ïà¹ØÎĵµ£º
ʹÊÔÒò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename ɾ³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......
1¡£web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2. c#´úÂëÖÐ
using System.Data.OracleClient;
public DataTable GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......
Oracle Data Guard, ·ÖÂß¼StandbyºÍÎïÀíStandby¡£ ÏÂÃæ½²µÄÊÇÎïÀíStandby »·¾³µÄ´î½¨²½Öè¡£ ÓйØData GuardµÄһЩ¸ÅÄîÐÔµÄÀíÂÛ֪ʶ£¬Çë²Î¿¼ÎÒµÄblog£¬ ÕâÀï²»×ö¹ý¶àµÄ˵Ã÷¡£
Oracle Data Gurad ÀíÂÛ֪ʶ
http://blog.csdn.net/tianlesoftware/archive/2010/04 ......
Temporary TablesÁÙʱ±í
1¼ò½é
ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
»òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
µ«ÊÇÁÙʱ± ......
DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔÒòÁ÷Â佺þ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......