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

On Wed, 24 Jan 2001 14:22:18 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

<snip>
>
>If you are pre-8i, then you can do the same thing, but instead of the
>ALTER TABLE MOVE command, you can *copy* the table with CREATE TABLE AS
>SELECT into the new tablespace. Then drop your original tables. Resize
>your datafile and copy the tables back.
>

<snip>

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)

Alex Received on Wed Jan 24 2001 - 10:52:13 CST