Re: Moving an 8i Database

You could run into a problem in Win2k with max file sizes depending on the format of your drives. I think Fat 16 is 2 gig and Fat 32 is 4 gig. Of course its probably NTSF formatted and your only limitation is partition size... anyways...

The most brainless way to do it would be a full export and import using oracle's export utility (cmd exp). Assuming you can deal with such hugemongeous files.

You could export each tablespace individually and reimport them.

If I had the time I would just:

1. Full export excluding the data
2. Import on the new server
3. Create a database link between the two servers
4. Write a script that dynamically creates 'select insert into' statements for all the tables by querying all_tables excluding sys and system etc. Be sure to log (sql plus spool) everything in case you get stuck somewhere and have to restart. If you do get stuck, just truncate the table you got stuck on and rerun the script starting with the table you just truncated.

COPY COPY COPY. Finito.

Danny

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1071252988.748728_at_yasure>...
> Coder wrote:
>
> > Hi, I've worked with Oracle a bit, but am still very much a newbie.
> >
> > I'm planning the move of a production database system from an old server
> > running Windows 2000 SP2 to a new one also running Windows 2000, but with
> > SP4 and all other updates.
> >
> > The current server is running Oracle 8i and another application on top of
> > it. The entire database is about 11GB.
> >
> > From my research it looks like there are several ways to move this database
> > over to the new server. What do you think is the best way to do the move it?
> > I need to get an identical configuration on the new server.
> >
> > Thanks!!
>
> Transportable tablespaces.
Received on Sat Dec 13 2003 - 15:55:32 CST