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
[mailto:oracledba-ezmlmshield-x49369873.[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