| Deleting unused tables [message #114897] |
Wed, 06 April 2005 03:03  |
raghuraja_r
Messages: 22
Registered: February 2005
Location: chennai
|
Junior Member |
|
|
Hi Buddys
In My lab more than 300 students are using the scott id for demo.
the database is growing very fast.
i want to delete all the tables those are not used for long time. Ho to do this and how do i get last accessed date of a table of tables that was last used some 1 month before.
once if many tables are deleted will my system.dbf file becomes smaller in size or not. if not how to reduce the size.
thanks in advance
regards
raghu r
|
|
|
|
| Re: Deleting unused tables [message #114908 is a reply to message #114897] |
Wed, 06 April 2005 05:46  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
unless you have enabled some kind of monitoring ( table monitoring / audit) , it is not possible to find the last accessible date.
deleting the table data, will not release space.
truncating / dropping will do.
Eventhough, it will not reduce the size of datafile.
Datafile is pre-allocated.
When you truncate data, the used space is released within datafile, and datafile filesize as seen in OS is NOT shrinked.
You need to manually shrink the datafile.
READ the administrator manual / search this forum for steps to shrinking the datafile.
If you have a database somewhat worth, do not use SYTEM tablespace to store custom objects
[Updated on: Wed, 06 April 2005 05:47] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
