Storage + Space Allocation problem...help !!!!!
Venkat Iyer
this is actually a difficulty i have run into while solving another one.....
i tried to get some free space on my drives...to my shock i found that the
datafiles constitute 1560 mb !!!!! and mind u ..this is on my laptop....i
have nowhere near that amount of data..as the laptop is only for my
development purpose....i just keep some sample data in the tables..so i
poked around and found some ridiculous settings for initial, next and
pctincrease for most of the tables, to the extent that some tables with just
a few records in them were blocking something like 90 mb...so i recreated
all the tables with decent storage allocations....bought in each table into
an extent and reclaimed around 400-600 mb....
but still i am not able to resize my datafile to a smaller size using the
"ALTER DATABASE DATAFILE "datafile path + name' RESIZE command ......it says
that some part of the datafile is in use...i can't figure out why this is
happening....i repeat....i have NOWHERE near that amount of data....and i
made *sure* i did the allocation rite coz it took me 4 days to get it
done.....
so *how* do i reclaim this "freed" space from my database's datafiles
??????? all these datafiles belong to the same tablespace used by my
application....indexes are in a separate tablespace of their own....
i have posted this also in the thread relating to my problem with the oracle
database assistants....along with further clarifications on that thread....
thanx in advance...and have a gr8 day :-)
venkat
mamba47
appropriate size and lastly import back the data into the same tablespace.
marc
"Venkat Iyer" <venkat...@yahoo.com> wrote in message
news:3abb4...@news2.tm.net.my...
xmark....@eds.com.x
approach. Disk space permitting, make a full export of the database
(compress=n). Create a create database script. Remove the database files
and recreate it. Import the data.
If the system tablespace is not oversized you can alter tablespaces offline,
drop them including contents, recreate them using smaller files, and import
the data as an alternate to recreating the entire database.
The reason you get the file in use message is just because you rebuild an
object does not mean that part of the object is not allocated in an extent at
the end of a file. You could try removeing all objects in the file,
resizing, and then reallocating the objects but I would go with the rebuild.
Good luck.
----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email ab...@newsone.net
