Re: Better method for importing?

> 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?

Yes you can rely on it. I have done it tons of times.

> 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).

First of all, you can export with full=y, but not import with it. The users that do not own db objects (non-schema users) you should recreate (those are simple create user commands) before importing. You may need to pre-create the roles as well, but if you do, you do not need to grant the roles to any users, the import will do that. This is not so much work...

When it comes time to import, do a full=n and use fromuser=(user1,user2,...) clause instead. Since the non-schema users are already there, they will be granted the appropriate rights.

Anyway, there are a million ways of doing this. you will be just fine with imp/exp, just do not import the system and sys schemas! Received on Fri Mar 09 2001 - 00:18:38 CST