Home » RDBMS Server » Server Administration » Tablespace autoextend (Oracle 8i database Windows 2000 Server)
Tablespace autoextend [message #301947] Fri, 22 February 2008 07:35 Go to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

I have a OEM Repository tablespace that has reached a size of over 2G is there anyway i can clear this tablespace o that i can reduce the size, also the auto extend limit has reached the maximum size so if i want to increase the size of the tablespace it has to be done manually can i just change the maximum size and allow the tablespace to extend automatically.
Re: Tablespace autoextend [message #301956 is a reply to message #301947] Fri, 22 February 2008 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER DATABASE, alter datafile clause, autoextend clause.

Regards
Michel
Re: Tablespace autoextend [message #301963 is a reply to message #301947] Fri, 22 February 2008 08:48 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

is there anyway that i can free up some of the space that the tablespace is occupying by purging it or removing data.
Re: Tablespace autoextend [message #301965 is a reply to message #301963] Fri, 22 February 2008 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same statement.
Search here for "shrink datafile" or the like, there are many topics on this subject.

Regards
Michel
Re: Tablespace autoextend [message #301996 is a reply to message #301965] Fri, 22 February 2008 11:14 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Michael is right, or other option is truncate historical data from tables under that tablespace after taking backup....
Previous Topic: Restrict the system connecting to the database
Next Topic: sys password for ASM instance
Goto Forum:
  


Current Time: Wed Dec 07 08:59:27 CST 2016

Total time taken to generate the page: 0.15612 seconds