Databases Reference
In-Depth Information
field3 char(2000) DEFAULT 'C' NOT NULL,
field4 char(2000) DEFAULT 'D' NOT NULL,
field5 char(2000) DEFAULT 'E' NOT NULL,
constraint PK_BIG_ROWS primary key (ID))
TABLESPACE EXAMPLE;
3.
Populate the table:
INSERT INTO HR.BIG_ROWS (id)
select rownum from all_objects where rownum < 101;
4.
Analyze the table to refresh the statistics:
ANALYZE TABLE HR.BIG_ROWS COMPUTE STATISTICS;
5.
Verify if there are chained rows:
SELECT CHAIN_CNT FROM ALL_TABLES
WHERE OWNER = ‹HR› AND TABLE_NAME = ‹BIG_ROWS›;
6.
In the next screenshot, we can see the results of these operations:
7.
Create a tablespace with a different block size:
CREATE TABLESPACE TS_16K BLOCKSIZE 16K DATAFILE 'TS_16K.DBF'
SIZE 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
