Home » RDBMS Server » Server Administration » deleting records
deleting records [message #332210] Mon, 07 July 2008 21:43 Go to next message
Messages: 226
Registered: March 2007
Senior Member
I have 10 tables in which i want to schedule a job that will delete records from all the 10 tables based on one condition.

Say, select cnt_id, per_id from table A
where user_id=x and country_id=y;

Now, I have to delete table 1 to table 10 based on cnt_id and per_id selected from the above query.

Is it a good ideal to run a job that deletes from all the 10 tables everyday or is there anyother way that i can do this?
Re: deleting records [message #332212 is a reply to message #332210] Mon, 07 July 2008 22:03 Go to previous messageGo to next message
Messages: 25574
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the Posting Guidelines as stated in URL above

This problem statement makes me doubt this "application" was designed to 3rd Normal Form.

[Updated on: Mon, 07 July 2008 22:27] by Moderator

Report message to a moderator

Re: deleting records [message #332803 is a reply to message #332210] Wed, 09 July 2008 14:46 Go to previous message
Messages: 25
Registered: May 2008
Junior Member
Oracle doesn't support mutliple table delete, some open source db like mysql supports it.
if tables are parent table and children tables, then you can use delete cascade.
Previous Topic: data purge
Next Topic: drop oracle8 database
Goto Forum:

Current Time: Mon Aug 21 05:24:33 CDT 2017

Total time taken to generate the page: 0.01502 seconds