If you want to see how much space your tables are taking in the database, log in to the shcema and execute this SQL.
The Above query tells you the table name, the table space it is residing in and the size in MB.
Thanks,
Zooz
| Title | Under | Posted on |
|---|---|---|
| Regarding Error "SQR 6002) CANNOT OPEN THE PRINTER FILE: " in SQR | PeopleSoft Technical | 11/21/2008 - 1:17am |
| Pay calendar Setup | PeopleSoft Functional | 11/18/2008 - 5:30pm |
| Issue linking to Excel 2007 from PS HRMS 8.8 | PeopleSoft Technical | 11/17/2008 - 9:48am |
| Spreadsheet-Based Control System Analysis and Design | Programming | 11/11/2008 - 5:10am |
Comments
Re: Get Table Sizes in your Schema
Join date: 06/23/08
To add to this, you can alter your current schema by using:
Also, if you want to avoid the schema thing all together, just replace the user_extents table with dba_extents table. You do however need to limit your where clause to go after specific OWNER or your SQL will take tremendous amount of time to execute.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Post new comment