How do I control the order of the output statements in the export?
Posted by:
Paul Whipp
Date: October 05, 2008 05:10PM
I have a simple model (extending a larger system) with two tables and three views. One of the views depends on one of the other views and fails on the import because the fields in the view it depends on are not defined (the parent view is appearing later in the script).
If I manually edit the file and swap the order of the views so that the base view is loaded first, everything works fine. However the workbench (5.0.25 SE) stubbornly writes them back in the wrong order every time I make a change. On larger systems this is going to be a nightmare.
By removing and re-adding the views (ctl-x, ctl-v in a new schema) I've managed a 'workaround' implying that the views are written out in the order they are added to the schema but this is not going to be viable in the general case.
How do I control the order of the output statements in the workbench?
Subject
Views
Written By
Posted
How do I control the order of the output statements in the export?
3090
October 05, 2008 05:10PM
2202
October 06, 2008 11:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.