Oracle指令

複製schema和data
create table new_table as select * from old_table;


複製指定欄位data
insert into new_table(column1, column2) select (column1, column2) from old_table;


跨database複製table

copy from username/password@ip:port/service to username/password@ip:port/service create table using select * from table;


*注意Table Engine和Character Set