Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving entire 8.1.7 database b/t machines
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