OraFAQ Forum: Server Administration » Tablespace autoextend

Home » RDBMS Server » Server Administration » Tablespace autoextend (Oracle 8i database Windows 2000 Server)

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

Tablespace autoextend [message #301947]

Fri, 22 February 2008 07:35

bank_master
Messages: 73
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.

Report message to a moderator

Re: Tablespace autoextend [message #301956 is a reply to message #301947]

Fri, 22 February 2008 08:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ALTER DATABASE, alter datafile clause, autoextend clause.

Regards
Michel

Report message to a moderator

Re: Tablespace autoextend [message #301963 is a reply to message #301947]

Fri, 22 February 2008 08:48

bank_master
Messages: 73
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.

Report message to a moderator

Re: Tablespace autoextend [message #301965 is a reply to message #301963]

Fri, 22 February 2008 08:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same statement.
Search here for "shrink datafile" or the like, there are many topics on this subject.

Regards
Michel

Report message to a moderator

Re: Tablespace autoextend [message #301996 is a reply to message #301965]

Fri, 22 February 2008 11:14

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....

Report message to a moderator

Previous Topic:	Restrict the system connecting to the database
Next Topic:	sys password for ASM instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:41:41 CST 2024