Re: Import Question

On May 31, 2:27 am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> ame..._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

the reason is clear, you are getting this error because the tablespace does not exist in the new database. just run the import with show=Y option and from the logfile, extract the tablespace creation script,create the tablespace manually and then run the import. It should be successfull now :)

Sidhu Received on Thu May 31 2007 - 11:36:14 CDT