This is common. Before you want to recreate the database you should
produce dynamic sql scripts (which you run against the source db) to
recompile invalid objects, recreate roles and grants. After you have
recreated the db run those scripts against the new instance. Good
planning will make this easier next time. Also, contact the NYOUG to
see if you can get a copy of their journal "Coalesce". It contains
scripts and excellent instructions to migrate a db.
hope_smith_at_hotmail.com wrote:
>
> 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 - 19:10:57 CDT
