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: Re-import Question

Re: Re-import Question

From: bigbrain <dougienator_at_gmail.com>
Date: 23 Oct 2006 14:24:45 -0700
Message-ID: <1161638685.220315.237720@i3g2000cwc.googlegroups.com> 





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:24:45 CDT












Original text of this message













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