sql>conn si/si@loca SQL> desc c Name Null? Type ------------------------------- -------- ---- C VARCHAR2(2)SQL> copy from si/si@loca to si/si@remo create c using select * from c;Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80) Table C created. 1 rows selected from si@loca. 1 rows inserted into C. 1 rows committed into C at [email protected]> conn si/si@remo Connected. SQL> select * from c;C -- okSQL>
SQL> desc c
Name Null? Type
------------------------------- -------- ----
C VARCHAR2(2)SQL> copy from si/si@loca to si/si@remo create c using select * from c;Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table C created. 1 rows selected from si@loca.
1 rows inserted into C.
1 rows committed into C at [email protected]> conn si/si@remo
Connected.
SQL> select * from c;C
--
okSQL>
exp 可以把数据倒出
imp 可以把数据导入