| Oracle 9i: calculating EXTENT [message #62600] |
Mon, 02 August 2004 18:08  |
Evelyn
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
The db block size is 4KB. You created a tablespace using the following command: CREATE TABLESPACE USER_DATA DATAFILE 'C:/DATA01.DBF' EXTENT MANAGEMENT DICTIONARY;
if you create an object in the database without specifying any storage parameters what will be the size of the 3rd extent that belongs to the object? The answer is 32KB. Can anyone give explanation?
THanks.
REgards,
Evelyn
|
|
|
|
| Re: Oracle 9i: calculating EXTENT [message #63505 is a reply to message #62600] |
Mon, 11 October 2004 16:33  |
Mario White
Messages: 1
Registered: October 2004
|
Junior Member |
|
|
|
If you create a table with the command: Create table table1 (col1 varchar2(30) primary key) tablespace testtable strorage(Initial 50M Next 100M Pctincrease 20) Minextents 1 Maxextents 200); How large the 4th extent Oracle allocates?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
