problem with import/export

The scenario is this:

I have a database (8.1.5), running on Win NT, which needs to be moved to another server
(8.1.7) running on Win NT.

When i make a export with "full=y" and do the import i get some errors:

• some errors regarding violation of contraints
• many errors that a pl/sql-procedure couln't be compiled.
  (because in the pl/sql-procedure a table/view is used, which will be
  imported later)

i know that i can disable the constraints and it's also possible to do the import one table after the other or one user after the other. but with 60 users and more than hundred tables that's not an easy way to go.

i thought the import-utility imports in the right order (=tables, contraints, procedures), but it seems it imports all tables of user A, all constraints and all procedures of user A, than the same with user B and ...

but it's a problem when a procedure of user A uses a table/view of user B and procedure of user B uses a table/view of user A. so i'll always get an error when i do a full import.
(i don't want to compile the procedures (with errors) on my own, because
there are more than hundred
procedures)

it there an easy way to solve my problem?

i'm only a software developer who also is responsible for the database, but i thought a COMPLETE backup of a database should be an easy task.

regards,
Martin Received on Sat Apr 28 2001 - 12:36:07 CDT