Forum Stats

  • 3,855,180 Users
  • 2,264,466 Discussions
  • 7,905,913 Comments

Discussions

rebuild index or shrink DBF

HI ,

need urgent help

i have deleted huge data from table now the table idx is 23 GB and used is 7% (1.3 GB).

likewise undotbs.dbf is 34 GB i am running out of space.

please help.

what is recuild index/ shrink tablespace diff? what is the solution?

THnaksssssssss in advance.

Tagged:
This discussion has been closed.