Data File size [message #49896] |
Sat, 16 February 2002 03:04 |
Manu Gupta
Messages: 44 Registered: January 2002
|
Member |
|
|
In Oracle 8.0 I want to resize the data files. I saw the details of datafile through enterprise manager. One of the file size is 1.4GB whereas it show only 69MB of file occupied. I tried to resize it but it showed me error ORA-03297. Please help.
|
|
|
Re: Data File size [message #49898 is a reply to message #49896] |
Sat, 16 February 2002 11:45 |
Kassim Kasmani
Messages: 25 Registered: January 2002
|
Junior Member |
|
|
The area you are try to trim has extents, may be due to fragmentation, thus, Oracle cannot resize the datafile because of the segments or extents that are there.
ORA-03297: file contains num blocks of data beyond requested RESIZE value
__________________________
Kassim Kasmani
Yahoo Messenger: kassim13
|
|
|
Re: Data File size [message #49911 is a reply to message #49898] |
Sun, 17 February 2002 20:39 |
Manu Gupta
Messages: 44 Registered: January 2002
|
Member |
|
|
Dear Kassim,
Thanks a lot for replying. I know that the problem is due to extents.Once there use to be large data in the file. Then I dropped segments containing large amount of data without deleting data first. Now I want to reduce the size of data files. Is there any method to do that?
|
|
|
Re: Data File size [message #49918 is a reply to message #49911] |
Mon, 18 February 2002 04:58 |
Sanjay Bajracharya
Messages: 279 Registered: October 2001 Location: Florida
|
Senior Member |
|
|
If you know the total amount of space used, then you can export the objects, shrink the data file and import the objects. During an import, space is allocated in sequential order.
Good Luck.
|
|
|