How much the inital of a table shoul be in order to maximize the space insde a manually tablespace ?
The data tablespace was created to manage "manually" the objects inside instead of "automatic".
Because we need to import those objects from prod to dev and dev also has the data tablespace as manually I want to pre-create those tables - index before importing the data in a way that will utilize in an effective manner the space in the data tablespace.
Do you know how much the "initial" should be ? do you think that 16 k is ok ?
CREATE TABLE ASAP.ACCESS_BILLING_CIRCUIT_LOC
(
CABS_CIRCUIT_ID NUMBER(9),
CABS_LOCATION_NUMBER NUMBER(9),
LOC_IND CHAR(1 BYTE),
REFERENCE_NUMBER VARCHAR2(4 BYTE),
Because we need to import those objects from prod to dev and dev also has the data tablespace as manually I want to pre-create those tables - index before importing the data in a way that will utilize in an effective manner the space in the data tablespace.
Do you know how much the "initial" should be ? do you think that 16 k is ok ?
CREATE TABLE ASAP.ACCESS_BILLING_CIRCUIT_LOC
(
CABS_CIRCUIT_ID NUMBER(9),
CABS_LOCATION_NUMBER NUMBER(9),
LOC_IND CHAR(1 BYTE),
REFERENCE_NUMBER VARCHAR2(4 BYTE),
0