Re: Question about full database import

In cases like this I have usually proceeded like this :

1. Re-create the tablespaces from the source db in the destination database with appropriate sizing for growth.
2. Perform a full export from the source database. Often I have exported with grants=n if I want to re-design security.
3. Perform a full import with ignore=y so that the "CREATE TABLESPACE" errors that you'll get (since you pre-created the tablespaces) won't cause any problems.

With this import all users will be re-created with the old passwords, and roles. Also all the tables, indexes, etc. will be created, with data (unless you import with rows=n).

If you just want to get the DDL for re-creating the users you can do this under Unix :

strings gigi.dmp | grep -i 'CREATE USER' > create_users.sql

Hope this helps.

On Sat, 18 Dec 1999 01:23:51 GMT, S. Han <shan168_at_yahoo.com> wrote:

>Deal all,
>
>We are about to export the full database and import it to another
>server. Since export doesn't export SYS schema. My question is: do I
>have to create all users/roles/profiles/schemas in the new database?
>
>Any help will be deeply appreciated!
>
>shan168
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

===

Yurasis Dragon
yurasis_dragonNOSPAM_at_yahoo.com
(remove NOSPAM to reply) Received on Sat Dec 18 1999 - 20:42:40 CST