Easy way to extract ddl of specific partitions in a partitioned table
Hello All,
I have a refresh requirement and have to refresh only specific partitions from partitioned table which has multiple partitions.I have many of such partitioned tables.For which i have to first create the structure of the table and then import the data.
Please let me know the easiest way to extract ddl of specific partitions of a partitioned table.
for ex: i have a partitioned table with 100 partitions in it but would like to extract only the ddl of the partitioned table + partitions 11,22,55,77.
tried sqlfile parameter but it gives full ddl of tables.