Re: Steps to clone a Oracle database to new machine??

Oops. "startup mount" should be "startup nomount"

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:993032932.29441.0.nnrp-01.c30bdde2_at_news.demon.co.uk...
> You are correct in your steps. Except you do not need "create all users"
> step. This is contained in the export file. You do not need to do anything
> to 'migrate users' when doing a full database import.
>
> "Eric" <h9515895_at_sinatown.com> wrote in message
> news:9gpfut$r48$1_at_hfc.pacific.net.hk...
> > Hi,
> >
> > I want to use exp/imp command to migrate my database to new machine.
 But,
 in
> > my database, there are over hundred users and with password. Is it mean
 I
> > need to create all users and give them a new
> > password? Is there any command can help to migrate the user to new
 machine
> > without changing the password?
> >
> > Is it the right steps to import a database:
> > 1> create new instance
> > 2> startup mount
> > 3> create database
> > 4> create tablespace
> > 5> create rollback segment
> > 5> create all users
> > 6> import the "export files"
> > 7> finish
> >
> > Thanks again
> > Eric Wong
> >
> >
> >
> >
>
>
Received on Wed Jun 20 2001 - 10:30:35 CDT