Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: copy user accounts
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