建立一个database link,通过create table aaa as select * from aaa@db_link, 或者用copy 命令
copy的用法: usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel> <db> : database string, e.g., scott/tiger@d:chicago-mktg <opt> : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE <table>: name of the destination table <cols> : a comma-separated list of destination column aliases <sel> : any valid SQL SELECT statement A missing FROM or TO clause uses the current SQL*Plus connection.
或者用copy 命令
usage: COPY FROM <db> TO <db> <opt> <table> { (<cols>) } USING <sel>
<db> : database string, e.g., scott/tiger@d:chicago-mktg
<opt> : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE
<table>: name of the destination table
<cols> : a comma-separated list of destination column aliases
<sel> : any valid SQL SELECT statement
A missing FROM or TO clause uses the current SQL*Plus connection.
imp test/test@servername fromuser=scott tables=yourtable file=a.dmp
不是在sqlplus下!!!
2.在PB中连接database2,打开表,倒入A.TXT文件
如:
14:15:46 SQL> host exp user/pw full=y file=fulldb.dmp