create tablespace / DEFAULT storage_clause
doroMar 30 2012 — edited Mar 30 2012Hello
since i don't have a 11g db installed for tests i want to know if something have change for the following in create tablespace syntax:
In 10gr2 docs it's stated that
"DEFAULT storage_clause
*This clause is valid only for a dictionary-managed tablespace*. Oracle strongly recommends that you create tablespaces that are locally managed rather than dictionary managed.
This clause lets you specify default storage parameters for all objects created in the tablespace and default compression of data for all tables created in the tablespace. This clause is not valid for a temporary tablespace."
(I've tried all storage attributes for a local managed tbs and even if i specify them they are all ignored)
In 11gr2 docs is stated that
"DEFAULT storage_clause
*This clause lets you specify default storage parameters for all objects created in the tablespace and default compression of data for all tables created in the tablespace*. This clause is not valid for a temporary tablespace.For a dictionary-managed tablespace, the only storage parameter you can specify with this clause is COMPRESS."
So, can you specify storage attributes for a local managed tablespace in 11g in a create tablespace statement ?