daniesh
asked on
what is the action to take when tablespace gets full on unix partition?
Hi Expert,
partition on unix is 100% on which my tablespace are present ? could you please help me
out?
partition on unix is 100% on which my tablespace are present ? could you please help me
out?
increase the size of file system....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok
i know that we can move some of the files to other partition
but the second option is that we can the tablespace
i need help on that.
i know that we can move some of the files to other partition
but the second option is that we can the tablespace
i need help on that.
ASKER
i mean the second option is that we can shrink the tablespace.
You can try rebuilding tables in your tablespace.. but that wont spare any physical space for you... you have to create another tablespace, move all the segments to that new one.. .drop your current tablespace.. and re-create with the size you believe is enough for your tablespace.. and bring the segments back.. see the following for details
https://www.experts-exchange.com/questions/22052299/Oracle-9i-and-Shrink-Bloated-Datafiles.html?anchorAnswerId=17892333#a17892333
https://www.experts-exchange.com/questions/22052299/Oracle-9i-and-Shrink-Bloated-Datafiles.html?anchorAnswerId=17892333#a17892333
I don't know if you can shrink the tablespace and the space taken on the HDD, but if you have multiple datafiles of that tablespace you may shift it to other disks / file systems.
omarfarid has given very good suggestion also.. consider moving some files to other disks if this is an option for u
ASKER
is there any command to rebuild tables....
i want to shrink tablespace for the time being
afterwards i will move the table to the other filesystem
for which i have bring the database down.
i want to shrink tablespace for the time being
afterwards i will move the table to the other filesystem
for which i have bring the database down.
you do not have to move your database down just for moving tables.. that can be done online.. you can even move your datafiles online.. (a small interruption might occur)
if your tablespace is 100% full.. then you cannot rebuild table without moving it to other tablespace... moving the table won't give you any physical space on file system.... it will free up your tablespace though
alter table your_table move another_table_space_name
if your tablespace is 100% full.. then you cannot rebuild table without moving it to other tablespace... moving the table won't give you any physical space on file system.... it will free up your tablespace though
alter table your_table move another_table_space_name
ASKER
i said if i prefer 1st option i.e to move the tablepspace to another files
in that case i have bring the database down.
in that case i have bring the database down.