need help on export/import

I had trouble in recent re-organization. At first, I thought a simple full database export/import would hnadle this one. But I was wrong. The following is what I did and found. The Oracle is 7.3.4 in IBM AIX 4.2.

1. Full database export with direct path under user system. Sucess without warning.
2. Delete database
3. Recreate database
4. Recreate tablespaces
5. Full database import under user system. Found more than one hundred invalid objects after importing. Most of them are views and package bodies. Import log file shows that these voews were imported before their base tbales were imported. Why Oracle did not handle the dependency. The worse is that some grants were not imported correctly because of the invalid objects.
6. Manually re-compiled invalid objects. Still did not how to figure whcih grants was not imported and how to import them again. Because there are too many grants that I could not walk through the import log file and make them one by one.

Oracle support suggested me to import again with grants=y, indexes=n, rows=n. But it was failed. Import log file shows that ome grants importing did not have sufficient proivileges although I did it again as user system.

Thanks

Hope

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 16 1999 - 11:37:04 CDT