Database Administration (MOSC)

MOSC Banner

Getting DDL of all the constraints and indexes on a table

edited Jun 9, 2017 5:00AM in Database Administration (MOSC) 15 commentsAnswered

Hi Team,

I need help to get the DDL of all the indexes and constraints on a table.

After taking the DDL I'll modify the index and constraint names to different name and apply it over another table which is just replica of the earlier table (only the earlier one is partitioned table and current one is non-partitioned and on a different tablespace)

Thanks,

Sandeep

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