Re: Import Question

On May 31, 2:16 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> 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??

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 - 13:42:18 CDT