Re: To free a db file, no other solution than exp/imp ??

> this is not a good idea if there are defaults set on the columns - the
> create as statement will not transfer them to the new table (at least
> not in 8.0.5.1)

I disagree. This is still a good idea. If you have defaults, or check constraints, or pk or fk constraints, etc. you will need to copy those. This is all part of stock database administration on moving only one table at a time without using export/import.

Thanks,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================