Comment embedded .......

==============

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "Puneyani, Rajesh" <[Email Address Removed] "Ankur Shah" <[Email Address Removed] "LazyDBA.com Discussion"
<[Email Address Removed] Thursday, January 29, 2004 3:38 PM
Subject: RE: Refreshing only Schema Objects (NOT DATA)


> Thanx Ankur,
>
> Pls clarify this - with this procedure all the NON-existing Tables etc
would
> be created...
> All the Existing Tables etc would be errored out

>>> Yes .

>
> BUT what is gonna happen to all those TABLEs/INDEXes/VIEWs etc
> Which are changed in source DB by the drop of a column or addition of
> column(s

>>>> U can drop the TABLES etc on source if U want to take care of the
added columns.

>
> How IMPORT is going to handle those modification ? Does it check
internally
> for this possibility ?

>>>> I usually run schema compare and add the columns manually
>
> Thanx and Regards
>
> -----Original Message-----
> From: Ankur Shah [mailto:[Email Address Removed] Sent: Thursday, January 29, 2004 3:28 PM
> To: LazyDBA.com Discussion; Puneyani, Rajesh
> Subject: Re: Refreshing only Schema Objects (NOT DATA)
>
>
> > Exp Dev with ROWS=N
>
> > Drop Packages on TEST
>
> > Imp in TEST with IGNORE=Y, FULL=Y
>
> ==================================
>
> HTHU
>
> Ankur Shah
> Oracle DBA
> DHR-GA
>
>
>
>
>
Oracle LazyDBA home page