Re: Importing a table from a dropped tablespace

From: Dieter Breisch <Dieter_at_Breisch.de>
Date: Mon, 17 Mar 2003 14:46:09 +0100
Message-ID: <b54jjh$8af$00$1@news.t-online.com>

Hi,

I would be interested in the answer too...

Dieter

"Yash" <yashgt_at_yahoo.com> schrieb im Newsbeitrag news:b3movl$lpl$1_at_news.vsnl.net.in...
> Hi,
>
> I had exported a partitioned table, that was in a tablespace named TBSP1,
> and dropped the table later. I now want to import it back. But the
> tablespace TBSP1 is no longer present in the database. Running the imp
> command even with ignore=Y, causes import to fail with ORA-00959, which
says
> "tablespace TBSP1 does not exist". Is it possible for me to get the table
> back without having to create the tablespace again?
>
> Thanks
> Yash
>
>
Received on Mon Mar 17 2003 - 07:46:09 CST