能將Oracle數據導入sql?
試試用DBLink連到另外一個庫上:-- Create database link create public database link 名字 connect to user identified by password using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = PORT)))(CONNECT_DATA = (SERVICE_NAME = SID)))';使用時候 可以使用select × from TB名@DBLink_Name