Database Administration (MOSC)

MOSC Banner

Default Storage Parameters for a Table

edited Mar 23, 2009 6:37PM in Database Administration (MOSC) 5 commentsAnswered
If a table is created by

create table tb_test (

sample varchar2(100)

) ;

Clearly storage or for that matter any extra parameter is specified , but a look

at all_tables provides us a set of values of MAX_EXTENTS . similarly for MAX_TRANS and other parameters.

Any idea on how oracle engine decides on these parameters ?

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center