| datafile problem [message #53039] |
Mon, 26 August 2002 07:12  |
Helena
Messages: 42
Registered: February 2002
|
Member |
|
|
|
I have created a newtablespace and the datafile is shows at 99% it did not clear up. what is the best way to clear up, and shoul it oracle automaticaly clear up the datafile.. any help would be great
|
|
|
|
| Re: datafile problem [message #53044 is a reply to message #53039] |
Mon, 26 August 2002 12:20  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Helena,
I am presumming a couple of things here.
You have a tablespace and you have a datafile member in it. It is at the moment showing 99% full. You mentioned that you have cleaned up but is not showing up. It can be due to the following reasons:
1. You DID NOT truncate the table or DROP the table.
2. You DELETEd records off the table.
Bottom line, space is freed up ONLY if you truncate the table or drop the table if possible. If you have trunctaed or dropped the tables to the maximum possible limit, then you are definitely running out of space, in which case, you need to either increase the size of the datafile (as allowed by OS) or add another datafile in the tablespace.
Oracle DOES NOT clean up any data files.
HINT: after you truncate/drop tables, coalesce the tablespace.
Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
