Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter storage of tabelspace influences table storage params????
Martijn Rutte wrote:
> After I changed the default storage parameters of a tablespace, do the
> default storage params of the tables created on this tablespace change
> too automatically(supposing that I did not specify any storage params
> while creating those tables initially, i.e. silently accepting the
> initial settings of the tablespace for all tables too)?
>
> Or do I have to change the storage params of the tables explicitly?
>
> Martijn
Explicitly.
But unless you have an older version of Oracle you should probably create one or more locally managed tablespaces with uniform extents and just move your tables there.
Daniel Morgan Received on Tue May 28 2002 - 10:34:20 CDT