Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: full import question
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.
Received on Sat Sep 16 2000 - 02:29:43 CDT