We are working with a database of size 46GB on Windows NT.
Our HDD is 80GB wiht 2gb Ram.
We have a Tablespace of 37 GB. It contains a Total free space is 2GB, but The maxmimum freespace is only 9mb. There are 1321 fragmentations.. Tables with the next extent of even 10mb cannot extend and shows errors while import happens. The Tablespace is Dictionary managed. The Tablespace Contains 1417 objects of two schema.
How can we defragment the Tablespace and make use of the 2GB. Will converting the Tablespace to LMT solve the problem. IF so how long(time) will it take to convert a 37gb Tablespace to LMT. If any other options are possible please provide it. All the objects are self contained in the same tablespace for both schemas.
Import And Export cannot be done on that box because of space constraint.
Success Consists of Getting Up Just One More Time Than You've Fallen Down
You can use: alter table xxx MOVE to move each table (1 at a time)
to another tablespace ... Coalesce the free extents in the tablespace.
and move back ... you need to map the blocks in the tablespace in
question to find out what objects need to be moved and removed...
Note: this will invalidate indexes associated with the tables that are moved... You will have to rebuild the indexes.
Well, I read it and other than having some "good to know info" it's pretty much out dated. If your company is on the bleeding edge of tech. Fragmentation is pretty much a thing of the past. Unless of course you have some goof ball create the tablespaces using dictionary managed. yes, you can still do it in 9i
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg
Originally posted by OracleDoc
. . . it's pretty much out dated.
Well, that's the trouble with databases - they're designed to store data. So any database that does it job tends to get out of date. (I guess I'm "out of date" too.) There's a poll round here somewhere which suggested that a very significant minority are still struggling with vsn7.