My suggestion is do not use AUTOALLOCATE. Use UNIFORM EXTENT SIZE with SEGMENT SPACE MANAGEMENT MANUAL.CREATE TABLESPACE TBS_LOBS DATAFILE '...'
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 16K
SEGMENT SPACE MANAGEMENT MANUAL;
Tamil




Reply With Quote