Re: Importing a table from a dropped tablespace

Hello Dieter & Yash,

Import only the partion u want.
If i'm not mistaken then the syntax is:

   imp usn/pwd tables=xxx:partition
but check the manual !

cheers

     Roelof Schierbeek

R.Schierbeek, DBA

 "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 Sat Mar 22 2003 - 19:48:06 CET