Create a new table
CREATE TABLE JOBS_TEMP AS SELECT * FROM HR.JOBS
Table created.
Query the USER_TABLES for storage parameters
SELECT initial_extent,
next_extent,
min_extents,
max_extents,
pct_increase,
blocks,
sample_size
FROM user_tables
WHERE table_name = 'JOBS_TEMP'
INITIAL_EXTENT | NEXT_EXTENT | MIN_EXTENTS | MAX_EXTENTS | PCT_INCREASE | BLOCKS | SAMPLE_SIZE | 65536 | 1048576 | 1 | 2147483645 | - | 4 | 19 |
---|
Alter the table by specifying new storage parameters
ALTER TABLE JOBS_TEMP MOVE
STORAGE ( INITIAL 20K
NEXT 40K
MINEXTENTS 2
MAXEXTENTS 20
PCTINCREASE 0 )
TABLESPACE LIVESQL_USERS
Table altered.
Query the USER_TABLES for storage parameters
SELECT initial_extent,
next_extent,
min_extents,
max_extents,
pct_increase,
blocks,
sample_size
FROM user_tables
WHERE table_name = 'JOBS_TEMP'
INITIAL_EXTENT | NEXT_EXTENT | MIN_EXTENTS | MAX_EXTENTS | PCT_INCREASE | BLOCKS | SAMPLE_SIZE | 65536 | 40960 | 1 | 2147483645 | - | 4 | 19 |
---|