Better method for importing?

From: Fred A G <nospam_at_allowed.localhost>
Date: Fri, 9 Mar 2001 03:12:18 +0100
Message-ID: <1YWp6.321$341.1322@nntpserver.swip.net>

Hi,
Can you rely on exp/imp for properly and cleanly "migrating" data from one (7.3.4) database to another (8.1.7) database, or are there other options?

A full+DBA export includes users, grants and such, but also objects of sys and system schemas, which could lead to a rather messy import. If not using full=y, then those things are not included (or so it seems).

One application has three schemas which could be copied using owner and fromuser export and import modes, but then a lot of stuff have to be manually (pre-) created (like users). With full import it would take a lot of editing the sql text beforehand to leave out the (unnecessary) sys and system stuff. Perhaps creating one "dummy" table per user could help, but that seems messy too...

Ideas, insights or anysuchofthesort would be appreciated.

Regards
/Fad Received on Thu Mar 08 2001 - 20:12:18 CST