Re: Cloning 21 GB Table - Review Approach please
- From: jungwolf <spatenau@xxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Thu, 10 Mar 2005 17:52:33 -0600
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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx'
> 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:-
--
//www.freelists.org/webpage/oracle-l
Other related posts:
