-
I need space on my disk, and i have a datafile that takes 6 gig. it contain only 3gig of data.
I want to resize and it gives me:
ORA-03297: file contains used data beyond requested RESIZE value
I did an alter table move tablespace
On all my table in the same tablespace.
I did a rebuild on all my index.
NOTE: I CANT DO A EXPORT/IMPORT because 24/24 database.
1. What oracle table or view can tell me wich object is beyond resize value?
2. I have also package, sequence, function and procedure, do i have to recreate them?
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
|