Hi
I want to alter tablespace ...
with only one storage parameters
alter tablespace users
storage(inittrans 4);
alter tablespace users
default sotrage(inittrans 4);
but its giving me error...
so can u give me idea....I mean proper syntax....
regards
Printable View
Hi
I want to alter tablespace ...
with only one storage parameters
alter tablespace users
storage(inittrans 4);
alter tablespace users
default sotrage(inittrans 4);
but its giving me error...
so can u give me idea....I mean proper syntax....
regards
inittrans is not a valid storage option.
It is a physical properties option specified for tables not tablespaces.
Why do you want to change this? Oracle recommends to keep it default.
Sanjay
check syntax in SQL Reference on tahiti.oracle.com