数据迁移相关笔记

1.表结构迁移

create table <USERNAME.TABLE_NAME>  tablespace <TABLESPACE_NAME>  as select * from <USERNAME.TABLE_NAME> where rownum<1