How to Create a copy of partition table?
570355May 4 2011 — edited May 4 2011hi,
I have a partition table that has 8 partition.
I would like to create a copy of this partition table.
I am use:
create table copy_partition_table as select * from partition_table where 1=2;
But when I create this table partitions are not created?
How can do that?
Could you please help me?
Thanks and regards,