OracleÊý¾Ý¿â±¸·ÝÓÐÄÄЩ£¿
OracleÊý¾Ý¿â±¸·ÝÓÐÄÄЩ£¿µ¼Èëµ¼³öµÄ¸ÅÄ
ËÏþµÃ£¬ËµÏÂÀ²
rman,imp,exp ¾³£Óõ½ÕâÖÓ£¬ÆäËûûÔõôÓùý
µ¼Èëµ¼³ö¸ÅÄîÊÇɶ
ÏȰÑÊý¾Ý¿âµ¼³öµ½Ò»¸ödmpÎļþÀï¡£
¿ÉÒÔÓÃÕâ¸ödmpÎļþ°ÑÕâ¸öÊý¾Ý¿âÔÚ»¹Ôµ½Êý¾Ý¿âÀï¡£
½¨ÒéÂ¥Ö÷Âò±¾Êé¿´¿´..
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ConnectÁ¬½ÓûÎÊÌ⣬²éѯÓï¾äÔÚworksheetÀïÄܲé³öÒ»Ìõ£¬µ«ÊÇreturn ocd.ExecuteReader()ȴûÓÐÕâÌõÊý¾Ý£¬Çë½ÌÏÂ
C# code:
string m_ConnectionString = "User ID=DQADMIN;Data Source=MyBASE;Pa ......
MSSQL2000 to Oracle 10g, text×Ö¶ÎÔõô´¦Àí£¿
ÓÃdtsµ¼Èë\µ¼³ö¹¤¾ß£¿
ѧϰ°ï¶¥²ä·Ö
sql server ÖÐµÄ±íµ¼µ½oracleÖУ¬ÔÚoracleÖжÔÓ¦textµÄÊý¾ÝÀàÐÍÊÇclobÀàÐÍ¡£
ÀûÓÃsqlserverµÄµ¼Èëµ¼³ö¹¦ÄÜ
× ......
żÓõÄÊÇOracle 10.1 G,Óöµ½ÒÔÏÂÎÊÌâ,µ÷ÊÔÁ˺ܾÃ,¾ÍÊǵ÷²»³É¹¦,ÇëÇóÍøÓѰïæ!
SQL> CREATE TABLE person (
2 pid VARCHAR2(18),
3 name VARCHAR2(200),
......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......