Database Administration (MOSC)

MOSC Banner

Easy way to extract ddl of specific partitions in a partitioned table

edited May 16, 2017 5:01AM in Database Administration (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center