--sqlplus copy可以自一個庫到另一個庫遷移資料庫表物件 SQL> copy usage: COPY FROM TO
{ () } USING : database string, e.g., hr/your_password@d:chicago-mktg : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE --建立,新增,插入，替換表或表的資料
: name of the destination table --建立的目標表 : a comma-separated list of destination column aliases --目標表的重新命名列 : any valid SQL SELECT statement --源庫的select子句用於產生目標表或資料所用
---如不指定目標庫,則為當前庫，同理如僅指定to則源庫為當前庫,to指定目標庫 SQL> copy from tbl_bck/system@second create t_test_copy using select object_id o bjectid from user_objects;
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 T_TEST_COPY created.
28 rows selected from tbl_bck@second. 28 rows inserted into T_TEST_COPY. 28 rows committed into T_TEST_COPY at DEFAULT HOST connection.
SQL> desc t_test_copy; Name Null? Type ----------------------------------------- -------- ----------------------------
OBJECTID NUMBER(38)
--與copy效能相關的引數為arraysize,copycommit,long SQL> copy from tbl_bck/system@second create t_test_copy_2 using select object_id objectid from user_objects;
Array fetch/bind size is 5000. (arraysize is 5000) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 80. (long is 80) Table T_TEST_COPY_2 created.
30 rows selected from tbl_bck@second. 30 rows inserted into T_TEST_COPY_2. 30 rows committed into T_TEST_COPY_2 at DEFAULT HOST connection.
