| Inconsistent Next_Extent Value In Oracle 8.0.4 [message #62397] |
Tue, 20 July 2004 00:46 |
Surash Natarajan
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
I have an Oracle 8.0.4 server running on Sun Solaris 2.6. I have noticed that when I recreate a table in another table space without specifing a STORAGE clause (using the tablespace defaults) the NEXT_EXTENT value is not consistent. For example:
My tablespace setting is:
TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT
XSITE 1048576 1048576
XSITE_INDEX 1048576 1048576
TEMPXSITE 16384 16384
TEMPINDEXXSITE 16384 16384
I'm recreating the tables from tablespace XSITE to TEMPXSITE using the following command:
CREATE TABLE PROD.TEXT_TABLE (
STRING_ID /* NUMBER(11) */ NOT NULL
, ROW_SEQUENCE /* NUMBER(11) */ NOT NULL
, TEXT_TOTAL /* NUMBER(11) */ NOT NULL
, TEXT_VALUE /* VARCHAR2(1786) */ NOT NULL)
Tablespace TEMPXSITE
PctFree 10
PctUsed 40
IniTrans 1
MaxTrans 255
Logging
NoParallel
NoCache
AS
Select
STRING_ID,
ROW_SEQUENCE,
TEXT_TOTAL,
TEXT_VALUE
From PROD.TEXT_TABLE;
After the table is created, I get the following values for INITIAL_EXTENT and NEXT_EXTENT:
OWNER TABLE_NAME INITIAL_EXTENT NEXT_EXTENT
PROD TEXT_TABLE 16384 66281472
The NEXT_EXTENT value should be 16384 which is the tablespace default but I get 66281472 which I have no idea how Oracle got this value. I have tried this with a number of different tables and for certain tables I get the correct value but for some tables I get different values.
Can anyone explain why is the NEXT_EXTENT value is not consistent with the tablespace default values when the STORAGE clause is not defined in the CREATE TABLE command?
Surash
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
