sqlserverºÍoracleÈçºÎ×öÊý¾Ý¿âͬ²½
ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£
Ìõ¼þ£º
oracle9i;sqlserver2000;
òËƲ»´ó¿ÉÄÜ
¾Í±»ÅÐËÀÐÌÁË£¿£¿
×ö¸öJOB
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
s1 a b c
1 a a a
2 b b b
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......