Check out my post on this at advancyn.com
bigbrain wrote:
> By the way make sure you backup first before you drop.. cascade or
> truncate ..the backup sometimes comes in handy.
>
> bigbrain wrote:
> > I think it depends on how your schema is setup. But I ussually drop the
> > entire schema using drop user ... cascade and them re-import the new
> > schema.
> >
> > klabu wrote:
> > > I need to RE-import set of tables/data from Prod schema into my
> > > schema....(why = get fresh data)
> > >
> > > Should I truncate or drop cascade the current (stale) set ?
> > >
> > > thanks
> > > --
> > > 10gR2
Received on Mon Oct 23 2006 - 23:31:41 CDT
