As a one off - or as a regular process, or as a real time process ?

For the one off, if you put this table into a tablespace of it's own, you
could transport it ?

Good luck,

Nick

-----Original Message-----
From: Qi cheng
[mailto:oracledba-ezmlmshield-x49369873.[Email address protected]
Sent: 06 July 2005 15:13
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


Feel better with BUPA
Visit http://www.bupa.com or call 0800 00 10 10 and find out what BUPA can do for you.


BUPA House 15-19 Bloomsbury Way London WC1A 2BA

Internet communications are not secure and therefore BUPA does
not accept legal responsibility for the contents of this message. Any
views or opinions presented are solely those of the author and do
not necessarily represent those of BUPA.
BUPA Insurance Limited, BUPA Health Assurance Limited, BUPA Insurance Services Limited and Goldsborough Estates Limited are authorised and regulated by the Financial Services Authority


Oracle LazyDBA home page