Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing a table from a dropped tablespace
"Dieter Breisch" <Dieter_at_Breisch.de> wrote in message
news:b54jjh$8af$00$1_at_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
> >
> >
>
>
what command are you using to do the import? Received on Mon Mar 17 2003 - 09:40:11 CST
![]() |
![]() |