RE: Replication of a large table

RE: Replication of a large table

 

  

CTAS when expanded means CREATE TABLE newtablename AS select * from oldtablename. You could control the storage parameters in the new table if you want or let oracle use the defaults and you could also control what you want get from the old table by appending a where clause after the oldtablename. I will definitely suggest you using larger initial and next extents because you are going to move millions of rows and that you leave the maxextents to unlimited initially.

Another important thing I want to suggest you is that you alter your session for bumping up the sort_area_size parameter to something like 10 MB. This will help you move data even faster.

Gurmohan
www.freemath.info




-----Original Message-----
From: Qi cheng [mailto:[Email address protected]
Sent: Wednesday, July 06, 2005 10:56 AM
To: Shergill, Gurmohan
Subject: Re: Replication of a large table


Thanks,

Have not idea what CTAS is, Can you give any link?

Qi

On 7/6/2005 10:50 AM, Shergill Gurmohan <[Email address protected] wrote:
>**A LazyDBA.com subscriber has responded to your lazydba.com post**
>**LazyDBA.com mail shield has forwarded you this email,
>**and removed any attachments, and kept your email address secret
>**from this person, and any viruses/trojans.
>**If you reply to this email, the person will see your email address
>as normal
>**Anything below this line is the original email text
>
>
>If you are attempting to recreate the table elsewhere then try using
>CTAS. This could be the fastest way of replicating. If your definition
>of replicating is something like as we use in materialized views
>then please disregard my suggestion.
>
>Gurmohan
>www.freemath.info
>
>
>
>-----Original Message-----
>From: Qi cheng
>[Email address protected]
>Sent: Wednesday, July 06, 2005 10:13 AM
>To: LazyDBA Discussion
>Subject: Replication of a large table
>
>
>Any one has the nice way to replicate over 60M rows of table to report
>database ? export and import is too time consuming, plus rebuild
>index will take for ever. Any one using material view against big
>table?
>Thanks.
>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>

Oracle LazyDBA home page