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

From: Alex Hudghton <alex_at_alenda.NOSPAM!.freeserve.co.uk>
Date: Sat, 27 Jan 2001 16:37:11 GMT
Message-ID: <3a719803.23146562@news.freeserve.net>

On Thu, 25 Jan 2001 13:50:28 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

<snip>
>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.
>

<snip>

Perhaps better worded this way - the documentation does not show that creating a new table with a 'create table as select ...' will not copy over column defaults.

Even Oracle Support had to run some tests to confirm this for me.

If you are not aware of this it can cause problems :-)

Alex Received on Sat Jan 27 2001 - 10:37:11 CST