Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃ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¡£ 
              ²»Í¬µÄ°æ±¾Ãû×ÖÓеãÇø±ð¡£
 
ʹÓÃÒѾ­ÅäÖúõÄÊý¾ÝÔ´¡£ 
 
Ñ¡ÔñÄã¸ÐÐËȤµÄÄÚÈÝ¡£ 
 
Éú³ÉÎïÀíÄ£ÐÍ¡£ 
 
ÎÒÃÇÉÔ×öµÈ´ý£¬ÎÒ³öÏÖÁËÎÒÃÇÐèÒªµÄÊý¾ÝÄ£ÐÍ¡£ÈçÏÂͼ£º 
 
·Å´óºó 
 
µ½ÕâÀÎÒÃǵÄÄæÏò¹¤³Ì£¬¾ÍÍê³ÉÁË¡£


Ïà¹ØÎĵµ£º

oracleÎóÓòÙ×÷ϵͳÃüÁîɾ³ýÊý¾ÝÎļþµÄ»Ö¸´·½·¨

ʹÊÔ­Òò:
1.ÓÉÓÚÎó²Ù×÷ÓÃhp unix ÃüÁî rm -f datafilename É¾³ý±í¿Õ¼äµÄÊý¾ÝÎļþ
2.alter tablespace tablespacenaem drop datafile datafile ;
3.drop tablespace tablespacename including content and datafiles;
ÉÏÊöÁ½¸ö²½ÖèÎÒÓÃÁ˽üÈý¸öСʱ¶¼Ã»ÓÐÖ´ÐÐÍ꣬×îºóµ¼ÖÂÊý¾Ý¿âå´»ú¡£ÏÂÃæ°ÑÎÒµ±Ê±Æô¶¯Êý¾ÝµÄºóÌ¨Ò ......

·ÃÎÊoracleÊý¾Ý¿â

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 Gurad Physical Standby Ïà¹Ø˵Ã÷


Oracle Data Guard, ·ÖÂß¼­StandbyºÍÎïÀíStandby¡£ ÏÂÃæ½²µÄÊÇÎïÀíStandby »·¾³µÄ´î½¨²½Öè¡£ ÓйØData GuardµÄһЩ¸ÅÄîÐÔµÄÀíÂÛ֪ʶ£¬Çë²Î¿¼ÎÒµÄblog£¬ ÕâÀï²»×ö¹ý¶àµÄ˵Ã÷¡£
Oracle Data Gurad ÀíÂÛ֪ʶ
http://blog.csdn.net/tianlesoftware/archive/2010/04 ......

OracleÁÙʱ±í

Temporary TablesÁÙʱ±í
1¼ò½é
   ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
   »òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
   µ«ÊÇÁÙʱ± ......

ORACLE DSI ½éÉÜ

DSIÊÇData Server
InternalsµÄËõд,ÊÇOracle¹«Ë¾ÄÚ²¿ÓÃÀ´ÅàѵOracleÊۺ󹤳ÌʦʹÓõĽ̲Ä.ÓÉÓÚijÖÖÔ­ÒòÁ÷Âä½­ºþ,
Êܵ½ÖÚ¶àOracle°®ºÃÕßµÄ×·Åõ, ²»¹ýÒªÊǹ¦Á¦²»µ½, ÔĶÁ·´¶øÎÞÒæ. DSI3ÊÇOracle 8ϵÁеÄ, DSI4ÊÇOracle 9ϵÁеÄ.
ÕâÑùµÄÎĵµÉÏͨ³£¶¼Ó¡×Å:Oracle Confidential:For internal Use Only.
DSI301 Advanced S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ