|
-
Hi,
You are saying that you can not resize the datafile. Check what extents are there in this file (tablespace) using dba_extents view. If at all there are any, you should have segments owned by sys only. If you do not find any segments then force the coalesce on this tablespace. This will make it contiguos. Then try resizing this datafile.
Baliga
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|