Re: Import Question

amerar_at_iwc.net schrieb:
> Hi,
>
> This is supposed to be very simple, but it is not happening.
>
> I exported a table. Big deal right? I want to import that table into
> another database in which the tablespace the table originally existed
> does not exist.
>
> I am receiving ORA-00959 errors. I have tried importing as system, as
> myself, with the ignore flag, without the ignore flag, using fromuser
> & touser..........it just keeps failing.
>
> IMP-00003: ORACLE error 959 encountered
> ORA-00959: tablespace 'DATA_HOLDER_DATA' does not exist
> Import terminated successfully with warnings.
>
>
> Though it says successful, the table is nowhere to be found in
> DBA_TABLES. We are on Oracle 8i.......
>
> Any suggestions??
>

I assume, this question is related to your previous post regarding nested tables.
Generally, you have two options by import to avoid ORA-00959: a) Get ddl of your table, adjust it and create your table before import in desired tablespace, then import with ignore=y b) Create tablespace with same name as in the source database. This apply to all tables which consists of more than 1 segments (hence have multiple storage clauses, i.e. partitioned tables, tables with LOB's, nested tables etc.)
Only simple heap tables which consists of 1 segment will be created in default tablespace if original tablespace doesn't exist.

Best regards

Maxim Received on Wed May 30 2007 - 16:27:57 CDT