Tag Info

New answers tagged


Prior to resizing, you have to remove fragmentation in the datafile. That means every segment (sets of blocks assigned to each object in that tablespace) needs to bring together all rows inside their db blocks. For this you have several options: If you're on 11gR2 you can use ALTER TABLESPACE <TABLESPACE_NAME> SHRINK SPACE KEEP 700M; That will ...


Table By Table - You can relatively easily do this. You need to create a filegroup, then a file in that filegroup and then you can move the tables you want to the new filegroup. Use the CREATE INDEX syntax with DROP EXISTING=ON and specify the new filegroup. The clustered index is the table so moving them this way moves the table. Your alternatives ...

Top 50 recent answers are included