Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Importing a table from a dropped tablespace

Re: Importing a table from a dropped tablespace

From: Kenneth A Kauffman <kkauffman_at_headfog.com>
Date: Mon, 17 Mar 2003 15:40:11 GMT
Message-ID: <v%lda.53300$Kc5.1868353@news2.east.cox.net>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US