GeeCON Prague 2014*
The moose likes Oracle/OAS and the fly likes Load one Oracle table with contents from three different tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Load one Oracle table with contents from three different tables" Watch "Load one Oracle table with contents from three different tables" New topic
Author

Load one Oracle table with contents from three different tables

Atul Mishra
Ranch Hand

Joined: Jun 08, 2006
Posts: 140
Hi all,

We have to create a new Oracle table using subset of data from 3 existing Oracle tables.
The data is huge, around 90M.

We have tried procedures which use Oracle JOINs across the three tables. The performace is not as quick.
Could anyone please suggest any tools/ faster mechanisms through which we can achive this ?

Thanks
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
I doubt you will find anything quicker than running a join in Oracle.
The only other thing you can check is if the fields you are joining on
are indexed in the tables.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Load one Oracle table with contents from three different tables