OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Purgeing data (9i and 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Purgeing data [message #357297]

Tue, 04 November 2008 14:18

jack00423
Messages: 4
Registered: July 2008

Junior Member

1-Can we purge data based on users(criteria) and time(from todate)?
2-if yes,Could you please tell how to do that.

Report message to a moderator

Re: Purgeing data [message #357298 is a reply to message #357297]

Tue, 04 November 2008 14:24

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Yes if you have the information for this
2/ Using the information on these parameters.

Regards
Michel

Report message to a moderator

Re: Purgeing data [message #357300 is a reply to message #357298]

Tue, 04 November 2008 14:30

jack00423
Messages: 4
Registered: July 2008

Junior Member

Hi,
Please tell me how to do that (any docs or notes for this)
Explain in detail please.How to specify the parameters for this ?
Thanks
Jack

[Updated on: Tue, 04 November 2008 14:33]

Report message to a moderator

Re: Purgeing data [message #357312 is a reply to message #357300]

Tue, 04 November 2008 19:26

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

It's not automated. You cannot specify a row to have a "default lifespan" after which it self-deletes.

If you want to remove data, you write code to:
- DELETE rows
- TRUNCATE tables or partitions
- DROP tables or partitions

Once you have written the code, you can schedule it to run automatically with DBMS_SCHEDULER()

Ross Leishman

Report message to a moderator

Re: Purgeing data [message #357315 is a reply to message #357297]

Tue, 04 November 2008 19:35

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

although you cannot create a row that will automagically delete itself after some period of time, you can create a view on top of your data that will stop showing the row after a specified period of time. Simply store the expiration date and code a where clause in the view to not show the row when sysdate <= expiration date.

Maybe this will suite your needs?

Kevin

Report message to a moderator

Previous Topic:	Query Tuning
Next Topic:	Dirty database_Performance issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 12:05:44 CDT 2024