ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©
ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿
¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡
Ò»°ãÊý¾Ý¿âÖеÄËùÓпØÖÆÎļþÖеÄÄÚÈݶ¼ÊÇÒ»ÑùµÄ£¬²¢ÇÒËüÃÇ´æ´¢µÄ¶¼ÊǶþ½øÖƵÄÄÚÈÝÐÅÏ¢¡£ËùÒÔÄã¿´¼ûµÄÄÚÈݾÍÊÇÂÒÂëÁË¡£
alter database backup controlfile to trace
controlÄãÊÇ¿´²»Á˵ģ¬Äã¿ÉÒÔ°´ÕÕlsµÄtrace³öÀ´£¬²»¹ýÕâÀï½ö½öÊÇcontorlµÄ½¨Á¢µÄsql¡£
Äã¿ÉÒÔͨ¹ýdumpÀ´°Ñcontrol file dump³öÀ´¡£
²Î¿¼ http://blog.csdn.net/inthirties/archive/2009/11/08/4786769.aspx
²»¹ýÕâÀïµÄÐÅÏ¢£¬ÐèÒªÒ»¶¨µÄѧϰ²ÅÄܶÁ¶®¡£
Ïà¹ØÎÊ´ð£º
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
ÒÔÇ°³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......