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: <oratune_at_aol.com>
Date: Sat, 16 Sep 2000 08:24:39 GMT
Message-ID: <8pvanv$48g$1@nnrp1.deja.com>

In article <8pv7gt$tt$1_at_nnrp1.deja.com>,   susana73_at_hotmail.com wrote:
> 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.
>

For the user specified, yes. All object parameters that default to 'Y' will be imported for the user. To see which parameters default to 'Y' type

           imp help=y

at the command line.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Sep 16 2000 - 03:24:39 CDT

Original text of this message

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