I have a normal table.
We need to change the INITRANS value for the table from 1 to 100.
Can we use ALTER TABLE to do this instead of dropping and recreating it?
The DB is a 11g R2.
The documentation is not clear on this. According to this documentation found here: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#i2192749
You can it seems change this property only for INDEX ORGANIZED TABLES.