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

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.

"splashy" <member32127@dbforums.com> wrote in message
news:3054675.1056836169@dbforums.com...

> Can you tell me what I need to do to overcome this problem in simple
> steps if possible please.

ignore=y
destroy=n

--
Cheers
Nuno Souto
wizofoz2k@yahoo.com.au.nospam

I created the tablespaces manually as advised without any problems, I
added the ignore Y switch to the IMPORT and it seems to be going well,
I also added the destroy N switch I assume that will prevent the export
from killing anythign it doesn't like or already exists (like my
tablespaces for example).

Thanks for your help I didn't have much hair left to tear out, much
appreciated.

--
Posted via http://dbforums.com