[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE: How to delete from multiple tables simultaneously
From:       Amin Adatia <amin_adatia () hotmail ! com>
Date:       2011-11-17 21:26:36
Message-ID: BLU164-W3025E9A22CF407B396AEEA83C70 () phx ! gbl
[Download RAW message or body]

I just inherited the situation. Before we had a Record-at-a-time and execute \
immediate.  
Triggers, FK with CASECADE Deletes are frowned upon as are global indexes on \
partitioned tables etc.. etc.. But things are getting better.

The Master Table has rows added to routinely so I had to use the BULK COLLECT \
approach and use rowid to only delete the records I had processed.

Regards 
Amin Adatia 
KnowTech Solutions Inc ( kttp://knowtech.ca )
Mobile +1-613-864-8378
 

> From: Barbara.Morris@icp.doe.gov
> To: ODTUG-SQLPLUS-L@fatcity.com
> Subject: RE: How to delete from multiple tables simultaneously
> Date: Thu, 17 Nov 2011 13:45:17 +0000
> 
> Are you saying the primary table contains the primary key and all the subsequent \
> tables have a foreign key to that table? If so you could setup the tables to handle \
> a cascade delete. The following is a link to a good write-up on this process. \
> http://www.techonthenet.com/oracle/foreign_keys/foreign_delete.php 
> 
> Thanks
> Barbara Morris
> Applications Development Team Lead
> 208-533-0733 Office
> 208-360-0865 Cell
> 
> 
> 		 	   		  


[prev in list] [next in list] [prev in thread] [next in thread]