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_at_news.t-online.com>
Date: Mon, 17 Mar 2003 14:46:09 +0100
Message-ID: <b54jjh$8af$00$1_at_news.t-online.com>
Hi,
[Quoted] 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 - 14:46:09 CET