OraFAQ Forum: Server Administration » tablespace management

Home » RDBMS Server » Server Administration » tablespace management

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tablespace management [message #57236]

Fri, 30 May 2003 01:24

rameshkumar
Messages: 12
Registered: May 2003

Junior Member

hai everybody,

i am facing a peculiar problem. it is as follows.

1.I want to copy records from one table to another table and delete them from the original. I am able to insert,and delete from the original. Both the tables belong to same tablespace. But, what i found is that the space is not getting freed up from the table in which i deleted the records. The used space is increasing.How can i solve?

2. When i am increasing the tablespace of TEMP by adding datafile, it is showing as added , but when iam querying the freespace, it is showing as not added.
. From the V$sort_segment, i am finding free blocks.

from dba_free_space, i am not finding the same.

Can anybody suggest me how to restore the available free space in tablespaces.

Report message to a moderator

Re: tablespace management [message #57239 is a reply to message #57236]

Fri, 30 May 2003 04:11

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

deleting wont free the tablespace.
u need to truncate the table.

1. let table1 is the source table.
2. create table table2 as select .... from table1;
3. now u have the records in table 2;
4. truncate table table1;
or
after deleting, move the source table to the same tablespace.
1. let table1 is source table.
2. insert into table2 (select ... from table1);
3. delete from table1.
4. alter table table1 move tablespace < same_tablespace_as_it_is >

Report message to a moderator