How to use storage... I'm using the following command: CREATE TABLE CH07NEW_ADDRESSES OF CUSTOMER_ADDRESS_TYPE because I'm creating an object table, but next I want the table to have 10MB...

Thanks. You know what you're talking about more than me, but it wouldn't read as: CREATE TABLE CH07NEW_ADDRESSES OF CUSTOMER_ADDRESS_TYPE TABLESPACE USER_DTAB STORAGE (INITIAL 10M NEXT 10M P...

PCTINCREASE determines how fast the size of the next extent to be added gets increased. So in your example, the initial extent would be 10M, the second would be 10M, the third would be 30M, the fo...

Oh gotcha. So if I do: STORAGE (INITIAL 10M NEXT 10M PCTINCREASE 0) The initial extent is 10M, second 20M, third 40M, fourth 80M ?? I want to double each time.

For that you would want STORAGE (INITIAL 10M NEXT 20M PCTINCREASE 100)