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

Home -> Community -> Usenet -> c.d.o.server -> Re: full import question

Re: full import question

From: <susana73_at_hotmail.com>
Date: Sat, 16 Sep 2000 07:29:43 GMT
Message-ID: <8pv7gt$tt$1@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. Received on Sat Sep 16 2000 - 02:29:43 CDT

Original text of this message

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