Re: Moving database from 8.1.6 to 8.1.7 with nonequal Tablespaces

If the tablespace does not exist on import, then the object will get created in the user's default tablespace. Since you have multiple tablespaces, you'll probably want to do something like the following:

1. Export old environment.
2. Run IMP with INDEXFILE=filename to create a DDL script.
3. Modify the above DDL script to create indexes and tables in appropriate new tablespaces.
4. Run the above modified script on new environment.
5. Import into new environment with IGNORE=Y.

HTH,
Brian

Marc Eggenberger wrote:
>
> 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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"