Re: It is a pain to use export/import

All views, procedures, functions and packages are created, but they are given the status INVALID (see dba_objects). You may fix this by issuing commands like 'alter view x compile' or 'alter package p compile body'. You may create a script that generates the necessary alter command automatically.

If you have problems with foreign key constraints because the referenced table does not exist yet, the easiest way is to run import again (and again ..), this time without importing rows.

Odd Harry Received on Thu Jun 13 1996 - 00:00:00 CEST