Re: full import question

Yes, but if someone has created an Index on Scott's table, then that index will not be imported, because it is *their* index, not Scott's.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<susana73_at_hotmail.com> wrote in message news:8pv7gt$tt$1_at_nnrp1.deja.com...


> Thanks Jez,

>

> Does "fromuser=scott touser=scott" import ALL the objects(tables,

> constraints, indexes, pl/sql packages)?

>

> Thanks,

>

> Susan

>

> In article <ZpAw5.5140$h21.81554_at_news6-win.server.ntlworld.com>,

>   "Jeremy Smith" <jeremy.d.smith_at_bigfoot.com> wrote:

> > It depends on what you've lost. If you know it's scott's schema  you

 can


> > drop scott which will delete all his tables, recreate scott and then

 use the


> > import fromuser=scott touser=scott to bring his tables back

> >

> > Jez

> >

> > <susana73_at_hotmail.com> wrote in message

 news:8puguc$8gg$1_at_nnrp1.deja.com...


> > > Hi,

> > >

> > > I have a daily full export(full=y) dump file.  My database isn't

 crash


> > > but we have screw up some of the logical data and we want to recover

 to


> > > the yesterday version.  Should I do a full import or drop all the

 tables


> > > then import each tables?

> > >

> > > Thanks,

> > >

> > > Susan

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.