Home » RDBMS Server » Performance Tuning » data purging from database
data purging from database [message #193531] Mon, 18 September 2006 02:35 Go to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
hi all,

Hi anyone explain the concept Data or table Purging. Suppose I do that what impact of database.
Please advise me.

Thanks
Manicm
Re: data purging from database [message #193578 is a reply to message #193531] Mon, 18 September 2006 05:57 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Are you referring to the PURGE TABLE/ INDEX/ TABLESPACE/ RECYCLEBIN commands?
Re: data purging from database [message #193622 is a reply to message #193578] Mon, 18 September 2006 08:55 Go to previous messageGo to next message
manicm
Messages: 11
Registered: August 2006
Location: SIngapore
Junior Member
hi
thanks for ur response.

yes I would like purging table.
pls advice me
thanks
manicm
Re: data purging from database [message #194085 is a reply to message #193531] Wed, 20 September 2006 14:21 Go to previous message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Refer this document to clear your doubts and requirement.

http://www.oracle.com/technology/pub/articles/10gdba/week5_10gdba.html

HTH
Manish
Previous Topic: redo files are on raid 5 ? why ?
Next Topic: sql query tuning
Goto Forum:
  


Current Time: Fri Dec 09 07:39:21 CST 2016

Total time taken to generate the page: 0.12895 seconds