Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû file︰輸³öÎļþµÄλÖúÍÎļþÃû tables︰輸³öµÄ±íÃûÁбí,¶à個±íÖÐ間Óöº號¸ô
Èç¹ûÊÇÏëµ¼³ö¾ÖÓòÍøÖÐÆäËû»úÆ÷µÄÊý¾Ý¿â£¬dbname´®Ó¦¸ÃÔõÑùдÄØ?
лл¸÷λ°ï棡
ÔÚÄã±¾»úµÄtnsname.oraÎļþÀï°ÑÆäËûµÄÊý¾Ý¿âÌí¼Ó½øÀ´
ICD_SFCC_PD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.8.22)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ÔÚÖØÆôϼàÌý¾Í¿ÉÒÔÁË.
lsnrctl restart
±ÈÈ磺Èç¹ûÄãtnsnameÀïдµÄÊÇICD_SFCC_PD
¾Í¿ÉÒÔÕâÑù£º
exp user/password@ICD_SFCC_PD file=c:\table.dmp tables=jbitaku,jbitakum
ÓÃnet managerÔö¼ÓÒ»¸öÁ¬½Ó´®,Æä·½·¨Îª:
¿ªÊ¼->ËùÓгÌÐò->Oracle-OraDb10g-home1->ÅäÖúÍÒÆÖ²¹¤¾ß->Net Manager->Oracle NetÅäÖÃ->±¾µØ
->·þÎñÃüÃû->²Ëµ¥±à¼->´´½¨
¸ü¼Ó¾ßÌåµÄÃèÊö¼û:
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/gettingstart.htm#sthref134
Èç¹ûÅäÖÃÒ»¸öÁ¬½ÓÆäËûORCLµÄÁ¬½Ó·û£¬È»ºóÓøÃÁ¬½Ó·û¾Í¿ÉÒÔµ¼³ö
±¨ÒÔÉÏ´íÎó
¿´²»µ½´íÎó¡£
sqlplus /nolog
conn user/pwd@Ô¶³ÌµÄ·þÎñÃû
±£Ö¤ÄãÄÜÁ¬½ÓÉÏ
Ïà¹ØÎÊ´ð£º
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
ÏÖÓÐÒÔÏÂÊý¾Ý£º
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²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......
table1:
uID uName
1 СÀî
2 СÕÅ
table2:
pID uID type
1 1 H1
2   ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......