Xref: alice comp.databases.oracle.misc:46579
Path: alice!news-feed.fnsi.net!dca1-hub1.news.digex.net!intermedia!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Billy Collins <billy_collins@my-deja.com>
Newsgroups: comp.databases.oracle.misc
Subject: From ORA 7.3 to ORA 8.05
Date: Thu, 11 Nov 1999 11:39:55 GMT
Organization: Deja.com - Before you buy.
Lines: 25
Message-ID: <80e9ub$jk5$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 11 11:39:55 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt)
X-Http-Proxy: NetCache@imscache05.netvigator.com: Version 3.4D8,NetCache@imscache01.netvigator.com: Version 3.4D8, 1.1 x29.deja.com:80 (Squid/1.1.22) for client 208.167.252.241,205.252.144.88, 205.252.144.9
X-MyDeja-Info: XMYDJUIDbilly_collins

HI

I have a simple question: we have finally decided its time to migrate
to the new db, and now are figuring out whats the best, most
recommended way of doing it?

1. Copy the old data to a temp table, and then, through SQL, insert
into the new database.

2. Use some sort of migration utility..does Oracle have one of its own,
and if yes, what could be possible drawbacks of this method?

3. <Insert any other idea here>


I would appreciate any and all experiences/suggestions!

Thanks a ton in advance..

Regards
Billy


Sent via Deja.com http://www.deja.com/
Before you buy.