Dear all,
I have a question about schema export/import by using imp/exp commands. Here is the environment:
I have two oracle instances (oracle version for both of them is 10.2.0.1.0). Both instances are installed on the same physical machine. The first instance is used for development (and also for check) and the second one is the backup of the first one.
Well, on the first instance there are several tables and views that have been created and work pretty well, without any problem.
However, there are several views that use other views (that had already been defined before them). These views are not imported properly during the backup process. It seems to me, that the order according to which the views had been defined is not respected. For example, let's say, you have defined two views named: myview1 and myview2. The view "myview1" was defined before "myview2" and the view "myview2" refers to the data visible in "myview1". As a result, during the import process on the backup instance, the very same order of definition has to be respected. Unfortunately, it seems that this is not the case and
as a result I receive error messages for several views.
Here is how I proceed:
The first instance from which I want to export data is: A971DEVT.WORLD
The second instance to which I want to import data (the backup instance) is: A972DEVT.WORLD
In order to create a dump I run the following
exp system/a971devt@a971devt.world file= A971DEVT_SIMAREP1.dmp log=971DEVT_SIMAREP1.log full=n owner=SIMAREP1 statistics=none
And in order to import the data on the other instance (backup instance) I run the following:
imp system/a972devt@a972devt.world file=A971DEVT_SIMAREP1.dmp log=A972DEVT_SIMAREP1_RESTORE.log full=n fromuser=SIMAREP1 touser=SIMAREP1
Any idea? How can I solve this poblem and import the views according to the correct order?
Thanks in advance,
Kind Regards,
Dariyoosh