Table deletion and creation

[Former Member]

Hello gurus ,

We have 2 table's occupied 70 gb , planning to delete the tables using se14 and recreate

/CWLD/LOG_HEADER

/CWLD/LOG_ITEM

is it good advice to do so its development system and need to do re-organization for table to get free space back.?

Please suggest

Bestregards

Vamsi

[Former Member · Accepted solution]

Is the database Oracle, then try to use Truncate if you want to just delte the data inside the Table rather than Dropping and recreate it.

SQL> TRUNCATE TABLE CWLD/LOG_HEADER,

/CWLD/LOG_ITEM

;

Table truncated.

You can reorganize after you have performed the above action.

Thanks

SM