Hi All

Ive got a database thats about 270 mb in size.

I deleted the majority of the data within the tables and commited
the transaction
but the size of the database remained the same size.

Why would this be ?

How can I delete the majority of the data within the database and
reduce the database file size ?

I have about 14 tables with 1 trigger and 1 generator per table and
about 8 of the tables have approx 3 indexes per table.

tia
Andrew