Home » RDBMS Server » Enterprise Manager » OEM_REPOSITORY Tablespace
OEM_REPOSITORY Tablespace [message #266704] Tue, 11 September 2007 08:09 Go to next message
bank_master
Messages: 71
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
Re: OEM_REPOSITORY Tablespace [message #266879 is a reply to message #266704] Tue, 11 September 2007 22:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check out the recycle bin object of this tablespace. Purge them.
Re: OEM_REPOSITORY Tablespace [message #266932 is a reply to message #266704] Wed, 12 September 2007 01:01 Go to previous messageGo to next message
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
Re: OEM_REPOSITORY Tablespace [message #267192 is a reply to message #266879] Wed, 12 September 2007 12:29 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

how do u do what u suggested a little new to this
Re: OEM_REPOSITORY Tablespace [message #267202 is a reply to message #267192] Wed, 12 September 2007 13:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"u" is not registered here and will not answer you.

Regards
Michel
Re: OEM_REPOSITORY Tablespace [message #267543 is a reply to message #266704] Thu, 13 September 2007 11:42 Go to previous messageGo to next message
bank_master
Messages: 71
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 Go to previous message
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.
Previous Topic: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
Next Topic: oracle moves to shutdown and automaticaly up
Goto Forum:
  


Current Time: Fri Dec 02 14:21:32 CST 2016

Total time taken to generate the page: 0.12675 seconds