OraFAQ Forum: Enterprise Manager » OEM

Home » RDBMS Server » Enterprise Manager » OEM_REPOSITORY Tablespace

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

OEM_REPOSITORY Tablespace [message #266704]

Tue, 11 September 2007 08:09

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

I have a problem where the tablespace that contains my OEM_REPOSITORY got filled up and i couldnt add any more jbs to the enterprise manager, i then had to increase the size of the tablespace which has now grown to over 2Gb. Is there anyway i could possibly truncate some of the information stored in this tablespace or dump it so as to free up some of the storage under this tablespace

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #266879 is a reply to message #266704]

Tue, 11 September 2007 22:17

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Check out the recycle bin object of this tablespace. Purge them.

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #266932 is a reply to message #266704]

Wed, 12 September 2007 01:01

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Which tablespace your using for OEM.
Bydefault or recommended your used SYSAUX tablespace.

go through below link for managing sysaux tablespace.
http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/tspaces.htm#sthref1208

Regards
Mohammed Taj

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #267192 is a reply to message #266879]

Wed, 12 September 2007 12:29

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

how do u do what u suggested a little new to this

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #267202 is a reply to message #267192]

Wed, 12 September 2007 13:14

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

Senior Member
Account Moderator

"u" is not registered here and will not answer you.

Regards
Michel

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #267543 is a reply to message #266704]

Thu, 13 September 2007 11:42

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

sorry about that the reply was direct to Arju for the suggestion he made about the recycle bin facility i would like to know how to go aabout doing this process.

Oh yeah the database is running on 8i

[Updated on: Thu, 13 September 2007 12:24]

Report message to a moderator

Re: OEM_REPOSITORY Tablespace [message #267872 is a reply to message #266704]

Sat, 15 September 2007 22:02

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

database is running on 8i

Then look some other person. I have not worked with 8i. New man in new era.

Report message to a moderator

Previous Topic:	ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
Next Topic:	oracle moves to shutdown and automaticaly up

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:52:54 CST 2024