Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: copy user accounts

Re: copy user accounts

From: S. Han <shan168_at_my-deja.com>
Date: Fri, 17 Dec 1999 18:00:32 GMT
Message-ID: <83dtnt$2sf$1@nnrp1.deja.com>


Well, my boss insists using Export, since we'll have to rearrange the location of all data files. Maybe I can try to export the "SYSTEM" tablespace so that all privileges are reserved. Hopefully it won't create any problems while exporting/importing the system tablespace.

Shan

In article <385A463D.D414EAAC_at_videotron.ca>,   Marc Mazerolle <informaze_at_videotron.ca> wrote:
> Why don't you physically copy the database files over to the new
server ?
> This will preserve ALL. Make sure the DB is down before copying.
>
> "S. Han" wrote:
>
> > We are moving the entire database from one NT to another.
> > I have to copy all user accounts/roles/profilesso that everything
will
> > be transparent to the users. How can I do this? Using a script (but
no
> > passwords) or export utility? Any help will be deeply appreciated!
> >
> > shan
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 12:00:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US