Moving database from 8.1.6 to 8.1.7 with nonequal Tablespaces

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Wed, 4 Jun 2003 16:29:53 +0200
Message-ID: <MPG.194820cc421c05bc9896a5@H02374>

Hi there.

I have a environment here which is running under Oracle 8.1.6 under WindowsNT. Now this environment has to be migrated to Oracle 8.1.7 under Windows 2000 Advanced Server.

I need to transfer everything to the new environment, but the tablespaces are named different ... the same ammount will be created but they will get an extra of 3 chars to each existing name.

How should I do this?

Creating Tablespaces on new env.
Doing a full export on old env.

Can I specify somehow which tablespace goes to which one on the new env?

Any hints?

-- 
mfg
Marc Eggenberger

Received on Wed Jun 04 2003 - 09:29:53 CDT