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 - 16:32:58 CDT
