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: Moving entire 8.1.7 database b/t machines

Re: Moving entire 8.1.7 database b/t machines

From: Tom <tomNOSPAM_at_eazyriders.com>
Date: Sat, 07 Sep 2002 21:09:41 GMT
Message-ID: <pWte9.4288$mf1.33439957@news-text.cableinet.net>

did you do full=y as this should take the users with it?

Tom

"Robert Banniza" <robert_at_rootprompt.net> wrote in message news:aldh71$4j8$1_at_news.laserlink.net...
> I have an Oracle instance I'm running on a Sun 3800. I'm wanting to make
 an
> exact replica of this database on a 420R for testing and general trashing
 to
> try to some new things. I thought using exp to export the entire database
> (COMPLETE) and then using imp on the 420 to import the database would do
> the trick. However, I'm getting all kinds of errors about users not
 existing
> and such. Therefore, how can I move the entire database without taking the
> prod database offline? If I am on the right track with exp/imp, can you
 tell
> me what flags I need to do this? I have looked everywhere and nothing
 seems
> to be working. I want to bring users over as well. Any help appreciated.
>
> Robert
>
>
Received on Sat Sep 07 2002 - 16:09:41 CDT

Original text of this message

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