Database Administration (MOSC)

MOSC Banner

How much the inital of a table shoul be in order to maximize the space insde a manually tablespace ?

edited Mar 30, 2011 9:23AM in Database Administration (MOSC) 3 commentsAnswered ✓
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),

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