Re: Question about full database import
Date: Sun, 19 Dec 1999 02:42:40 GMT
Message-ID: <385c456c.84509448_at_news.rdc1.ab.home.com>
In cases like this I have usually proceeded like this :
- Re-create the tablespaces from the source db in the destination database with appropriate sizing for growth.
- Perform a full export from the source database. Often I have exported with grants=n if I want to re-design security.
- 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 Sun Dec 19 1999 - 03:42:40 CET