create a copy of partition table with data
653303Jun 22 2010 — edited Jun 22 2010I need to create a script which will select some partitioned tables from sys.all_tables based on some condition (such as PARTITIONED ='YES') and create a copy of the table with data.
The copy should be replica of orginal table i.e it should also be partitioned.
can you pls suggest the possible approches that I can followe to come up with an automated script i.e I run the script and copies of all the tables are created in same schema.
Thanks