Re: Moving an Oracle database

In article <hl0q3.1963$hm3.3846_at_news2.mco>,   "Darryl Brown" <brown_at_lunartech.com> wrote:
> Hello All,
>
> I hope this is not the wrong group to ask this question of.
>
> I am looking for a way to move my Oracle 8 database from one test
server to
> my other test server and I have been trying to use Enterprise Manager
to
> move the data base without success.
>
> Does any one have an Idea on how to do this, I have also been looking
> through several books and I have no been able to find any information
on
> this.
>
> I will try support but the wait time with them is usually
unreasonable.
>
> Thanks for the help.
> Darryl
> brown_at_lunartech.com
>
>

There are at least two good ways to do this:

1. If the original database is not too large, a very simple way to do it is to export it with full=y and compress=n. Then, import it into a new database instance.
2. Another good way, especially if the database is very large, is to copy the datafiles (with the original instance shut down) to new files, then bring up a new instance with a new name using the new files. This is a fairly complex process - obtain a copy of Oracle Corporate Support Problem Repository paper number 1006497.6 for all the gory details. You can get this paper from MetaLink or other sources.

Hope this helps,
Tim

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 13:23:18 CDT