Re: Cloning 21 GB Table - Review Approach please

Total conjecture here. Any chance you're using 10g? It has a "rename tablespace" command which might allow you to use transportable tablespace export/import...

Has anyone tried anything like this for a table clone operation? If so, how did it compare to other methods?

Steven

On Thu, 10 Mar 2005 15:36:40 +0530, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Will Arhive Redo Log be generated by the INSERT /*+ APPEND */ Command if =
> the Target Table has been PRE-Created with NOLOGGING?
>
> Any possibility of giving Hint for NOLOGGING in the INSERT Command ?
>
> -----Original Message-----
> From: VIVEK_SHARMA=20
> Sent: Thursday, March 10, 2005 3:31 PM
> To: 'oracle-l_at_freelists.org'
> Subject: Cloning 21 GB Table - Review Approach please
>
> We are to clone a 32Million records table of approx 21GB in the same DB.
> =A0
> We are considering the following approach:-

--
http://www.freelists.org/webpage/oracle-l