Re: Can't import from 8.05 to 9.3i need help

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Sat, 28 Jun 2003 17:48:30 -0700
Message-ID: <zHqLa.113441$MJ5.6248@fed1read03>

splashy wrote:
> Hi guys,
>
> Firstly let me apologise for my complete lack of knowledge in terms
> of oracle but I have a job to do and well I'm struggling to do it to
> be honest.
>
> I have an export dump from an Oracle 8 db, that I need to get into a new
> 9i instance. The problem is that the old export wants to create
> dictionary manged tablespaces and the new db uses locally manged
> tablesapces.
>
> All i get at the moment is "cannot create dictionary manged tablespaces"
> error messages.
>
> Can you tell me what I need to do to overcome this problem in simple
> steps if possible please.
>
> Thanks in advance for any help offered,
>
> :)
>
> --
> Posted via http://dbforums.com

Manually create the tablespaces prior to the import.

CREATE TABLESPACE FOOBAR ...... Then include "IGNORE=YES" when doing the import. Received on Sat Jun 28 2003 - 19:48:30 CDT