Re: Import Question

amerar_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??
>

If the tablespace does not exist, the table should get created in the user's default tablespace. But you can precreate the table in any tablespace you want and then import with IGNORE=Y. To get the CREATE TABLE command, use SHOW=Y to see the dump file's DDL statements. Also use the SPOOL parameter with SHOW=Y to write the output to a text file which you can then edit into your CREATE TABLE statement.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com