Difference between 2 Tables, 22 GB each.
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Apr 2005 20:01:41 +0530
Folks
Need to get=A0the difference records between 2 tables each of size 22GB =
(each containing 32 Million rows). The temp tablespace is 30GB.
What would be the fastest/most efficient way?
=A0
Machine configuration - 4 cpu's and 1GB DIMM RAM.=20
OS version - Unix Sun Solaris machine Version not known.
Oracle version -=A0 8.1
Nature of application -=A0Joins and inserts
production issue -=A0 Yes
Tables being accessed by other applications - YES, during certain time =
slot. We have abt 12-14hrs when they are not touched by any application.
=A0
Thanks
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Difference between 2 Tables, 22 GB each.
