Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting / Importing Database Users
Having done it myself several times, it is relatively simple as long as you avoid
a few pitfalls:
1 Make a full database export of the old database
2 Create the new database
3 Create a second rollback segment in the SYSTEM tablespace. (Why that's not
included in the default install I don' know. I assume no one is using a one
tablespace database. I allways forget to do it initially)
4 Create all tablespaces in the new database. Tablespace name shouldn't change,
filenames of datafiles MUST change. If you don't have a script that will generate
a create tablespace script for you, look on the support notes cd, or reply to this
e-mail and I will send one to you. Don't have it with me currently.
5 perform a full database import with ignore=y and log=<some filename>. Ignore is
necessary as they are create tablespace statements in the import, and the
tablespaces are already.
Hth
Sybrand Bakker
(postbus_at_sybrandb.demon.nl)
jtesta_at_my-dejanews.com wrote:
> You just want to export the users, how about using sql to build sql instead.
>
> like this:
> select 'create user '||username||
> ' identified by values '||''''||password||''''||
> ' default tablespace '||default_tablespace||
> ' temporary tablespace '|| temporary_tablespace||';' from
> sys.dba_users;
>
> This does NOT do grants, quotas, etc, but its a starting point for you to
> build on.
>
> you do a spool on BEFORE running this and a spool off AFTER.
>
> then all u have to do is @spoolfilename
>
> hth, joe
> http://www.oracle-dba.com
>
> In article <6qdchh$9n3$1_at_flint.sentex.net>,
> "Dennis R. Leon" <dleon_at_rim.net> wrote:
> > I'm trying to export all the users from one database and then importing them
> > to a brand new database.
> >
> > Everything I tried failed!!!
> >
> > Does anybody know how this can be done? (I'm new at this!)
> >
> > Your help would be greatly appreciated.
> >
> > ~~~~~~~~~~~~~~~~~~~
> > Dennis R. Leon
> > dleon_at_rim.net
> >
> > Research In Motion Ltd.
> > http://www.rim.net/
> >
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Aug 08 1998 - 05:00:32 CDT