| Complete newbie question [message #528028] |
Fri, 21 October 2011 05:23  |
 |
Kwisatz78
Messages: 24
Registered: October 2011
|
Junior Member |
|
|
Hi all
Whats the easiest way I can see a list of tablespaces and what tables and indexes are in those tablsespaces?
Can this be done through OEM?
Sorry for the newbiest of newbie questions.
|
|
|
|
|
|
|
|
| Re: Complete newbie question [message #528347 is a reply to message #528028] |
Mon, 24 October 2011 06:55  |
daverich
Messages: 23
Registered: January 2010
Location: UK
|
Junior Member |
|
|
Yes, you can also view this information from OEM.
You can do this ( I am using OEM 11g Grid Control):
1. Go to Targets->All Targets
2. Select the Database instance
3. Select Server Tab.
4. Select Tablespaces.
5. Select the tablespace you want to check (double click)
6. On View tablespace screen select "Show tablespace contents". Then Click Go.
Contents of that tablespace will be retrieved and displayed on OEM.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
