Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablespace full

547581May 11 2007 — edited May 11 2007
hi experts

i am using oracle 9i on linux i have a tablespace xxx and there r round abt 3 cr rows in that.
my problem is i want to empty that tablespace because it is almost full.
now, what i did, i have made another tablespace on another disk and transfer one of the table containig 1 cr data from xxx tablespace .
and drop that table from xxx tablespace
is that a right practise to do
or is any thing better i can do
plz help

thanks
varun
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2007
Added on May 11 2007
9 comments
538 views