This content has been marked as final. Show 5 replies
THere is no segment advisor, but there is a Shrink table option in the context menu for tables.
Right-Click | Storage | Shrink...
is there any way to shrink full database?
Edited by: 944768 on Jan 26, 2013 8:31 AM
Edited by: 944768 on Jan 26, 2013 8:32 AM
You can use the data file editor to resize datafiles, but the amount you can shrink will depend on how fragmented the free space is.
please tel me where i can find datafile editor.
i am newbie
View > DBA1 person found this helpful
Add connection to your database
Then drill into the Storage node. Select your tablespace and resize your file.
As a newbie, I recommend you read the Oracle docs on tablespace management.