Dear Sir,

Help me in shrinking table space. How can i shrink the tablespace of a particular Table.As we can use the truncate command in oracle to shrink a particular table space.Is the any command that i can shrink the table space. My database is around 12GB with log file. It is impossible to maintain it now. Please give me solution that i can shrink my tablespace.

Waiting for your reply

Regards

MOnojit Das

-- Anonymous, May 05, 2004

Answers

Monojit,

In Enterprise Manager, right-click the database to shrink, point to All Tasks, and then click Shrink Database.

Hope this helps,

Eric

-- Anonymous, May 21, 2004