I want to backup my database, including tables, constraints, procedures,packages, primary keys, indexes etc.
I have found DBMS_METADATA.GET_DEPENDEN
T_DDL() function helpful
I also found this link helpful
In the section "Issues with dbms_metadata"
When you have foreign keys (“references” constraints), it would be nice to punch the table DDL in their proper order for re-loading into another database. If you do not order the table, a table may be added that references another table that has not yet been added. Making this change would involve adding a WHERE clause that queries dba_constraints and dba_cons_columns to determine the proper table order.
How do I use dba_constraints and dba_cons_columns to retrieve the table in the proper order?
Any example would be highly appreciated.
thank you very much for all your help!