Hi guys
We've a legacy database 10g Release 1 & the vendor has configured export dump as the sole backup that happens everyday midnight. As the hardware started giving some issues those cannot be fixed, we are planning to move the database to new hardware (Windows environment)
We were able to successfully import the objects using import, however noticed that many warnings about non-existing objects (tables especially on which currently imported schema having read/write accesses belonging to other schemas). Subsequently all the schemas are imported & my question is, should we exclusively re-assign the rights on the objects those were not existing while a particular schema was imported or as all the related schemas were imported successfully, the rights will be implemented automatically?
Example scenario
We have five schemas fin, om, lc, payroll and fa (standing for finance, order management, letter of credit, fixed assets & payroll). The import parameter file was structured the same way I listed the objects & we start seeing warnings about non-existing tables those are referred by finance owned by other schemas.
Thanks in advance
rajesh