ORACLEÃâ·Ñ¹«¿ª¿Î
²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍΪËùÓеIJÆÎñÐÅÏ¢ÌṩÁ˵¥Ò»¾«È·µÄÊÓͼ£¬Ò²°üÀ¨360¶ÈµÄ¿Í»§È«¾°¡£OracleÌṩ²ÆÎñÄ£¿éÉî¶ÈÅàѵ£¬°ïÖúÆóÒµÓ¦ÓÃϵͳ»ñµÃÐÐÒµÁìÏȵÄÐÔÄܺͿÉÀ©Õ¹ÐÔ¡£
²©ÑåOracle erp¹ËÎÊѧԺӦ¹ã´óѧԱµÄÇ¿ÁÒÒªÇó£¬ÌØÔÚ±±¾©¼°ÉϺ£¾Ù°ìOracleµç×ÓÉÌÎñÌ×¼þR12²ÆÎñÓ¦ÓõÄÃâ·Ñ½²×ù£¬¾ßÌå¿ÎÄÚÈݰ²ÅÅÈçÏ£º
No
¿Î³ÌÃû³Æ
¿Î³ÌÃèÊö
ʱ¼ä
1
R12 Oracle µç×ÓÉÌÎñÌ×¼þʵʩ¹æ»®Ö¸ÄÏ
½éÉÜR12Ó¦ÓÃϵͳµÄ»ù±¾²Ù×÷
2010
´ý¶¨
2
R12 Oracle ×ÜÕ˹ÜÀí»ù´¡
½éÉÜR12×ÜÕʱê×¼¹¦ÄܵIJÙ×÷ºÍÉèÖÃ
3
R12 Oracle Ó¦¸¶¹ÜÀí»ù´¡
½éÉÜR12Ó¦¸¶·¢Æ±¡¢Ó¦¸¶¿îÏîºÍÍøÉÏ·ÑÓúËÏúµÈÇ¿´ó¹¦ÄÜ
½²×ùµØÖ·£º´ý¶¨
×Éѯµç»°£º010---82826100--2246 ºÂС½ã
±¨Ãû±íÏÂÔØ£ºhttp://edu.beyondsoft.com/images/upfile/20091020145656481.doc ÌîдºÃ±¨Ãû±í·¢ÖÁ haoguojing@beyondsoft.com
Íø Ö·£ºhttp://edu.beyondsoft.com
QQ£º 297539145
MSN£º haoguojing01@hotmail.com
ÈÏÖ¤½»Á÷Ⱥ£º108882889
Ïà¹ØÎĵµ£º
1. Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2. ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐǰ½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡£
3. ......
1¡¢Ä¬ÈÏÊÂÀý£º
Óû§Ãû£ºscottÃÜÂ룺tiger Ö÷»ú×Ö·û´®£º±¾»ú¿ÉÒÔΪ¿Õ
2¡¢Æô¶¯·½·¨£º
ÔËÐУºsqlplus scott/tiger@lhd
3¡¢SQLPLUS»ù±¾ÃüÁ
Desc£ºÏÔʾ±í¡¢ÊÓͼ½á¹¹ desc ±íÃû£¬ÊÓͼ
List£ºÁгöSQL»º³åÇøÇøÖеÄÒ»Ðлò¶àÐÐÃüÁîÓï¾ä
Exit£ºÍ˳ö
4¡¢³£ÓõÄÊý¾Ý×Öµä(ÈýÖÖǰ׺£ºUSER£¬ALL£¬DBA)
USER_TABL ......
Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......
Oracle Data Guard, ·ÖÂß¼StandbyºÍÎïÀíStandby¡£ ÏÂÃæ½²µÄÊÇÎïÀíStandby »·¾³µÄ´î½¨²½Öè¡£ ÓйØData GuardµÄһЩ¸ÅÄîÐÔµÄÀíÂÛ֪ʶ£¬Çë²Î¿¼ÎÒµÄblog£¬ ÕâÀï²»×ö¹ý¶àµÄ˵Ã÷¡£
Oracle Data Gurad ÀíÂÛ֪ʶ
http://blog.csdn.net/tianlesoftware/archive/2010/04 ......
Ò»¡¢²éѯij¸ö×Ö¶ÎÖØ¸´
select *
from User u
where u.user_name in (select u.user_name
&nbs ......