Re: resetting initial_extents

On Thu, 05 May 2005 06:07:30 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>Is there any method of resetting storage parameters on a bunch of tables?
>Perhaps something with exp/imp that would recreate the tables with the
>default storage parameters? Some procedure that would retain data,
>constraints and grants.
>

imp doesn't recreate any tables if they already exists. It either errors out, or ignores the errors.
You'll need to drop the tables and recreate them manually prior to import.
If you don't have your create table scripts, you can generate them from imp by using show=y log=<any filename> and possibly edit <any filename> by removing extent definitions.

--
Sybrand Bakker, Senior Oracle DBA