Hi,
I need to delete a range of tables which I don't need.
I am using session ttaad4231m000 (Delete Tables) to delete the tables.


What happens to the Indices against those tables which have been deleted ?
Is the free space created on deleting the tables used by database ?
What should I do to make use of the free space created ?


regards
Sriks

Hi,

What happens to the Indices against those tables which have been deleted ?
Is the free space created on deleting the tables used by database ?
What should I do to make use of the free space created ?

Sriks
1. Indices will get deleted.
2. Oracle does not free up the space.
3. Somebody with experience can help on this.

In general:

Don't delete tables of an operational company if there are any references to these tables from other tables. You might experience problems when you are trying to delete records in other tables.
Also you might get into problems when installing service packs and solutions.

Hi,
I need to delete tables from a dummy company. I am not droping tables from operational company

regards
Sriks

Baan sends create/drop commands to Oracle related to tables. So by deleting the tables from Baan you are freeing up space in the database (you may however end up with defragmentation).
Baan does not send create/drop commands for tablespaces.