Suppose I want to perform data migration operation for which I would like to load the parent tables first and then the child tables for the obvious reason. Some of these tables play dual role. Assume the number of tables is huge in a schema. What would be the query that gives me the list of tables in that order which I can perform migration.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
To do that you could try:
Datapump uses a similar strategy to prevent constraint violations. I hope this helps.
Starting with Frank Kulash's example of a hierarchial query against the
will give you the tables in the order they should be loaded (assuming there are no cycles in the data). If you want to load in parallel, all tables with the same