Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create tablespace / DEFAULT storage_clause

doroMar 30 2012 — edited Mar 30 2012
Hello
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 ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2012
Added on Mar 30 2012
2 comments
382 views