在网上查的复制表结构两种方法,
1: create new_table_name as (select * from old_table_name where 1=2);
只复制表结构,没有主键,没有数据
2: create new_table_name like old_table_name
复制表结构,带数据,没有主键
3:
declare
createsql varchar(4000);
newtablesql varchar(4000);
begin
select dbms_metadata.get_ddl('TABLE','${cloneTableName}') into createsql from dual;
select replace(createsql, '${cloneTableName}', '${tableName}') into newtablesql from dual;
execute immediate newtablesql;
end;复制表结构,带主键,没有数据