Hi,

I used the following statement to create a tablespace:

CREATE TABLESPACE "PSAPROGD"
DATAFILE '/oracle/QA2/sapdata9/rogd_1/rogd.data1' SIZE 8191992K
AUTOEXTEND ON NEXT 2000M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576K

After it was created and I found out it's file_id is 160.
Then I did the following:

SQL> select sum(bytes) from dba_data_files where file_id=160;

SUM(BYTES)
----------
8388599808

SQL> select sum(bytes) from dba_free_space where file_id=160;

SUM(BYTES)
----------
7516192768

What happened to those 832 MB (8,388,599,808-7,516,192,768 = 872,407,040) ?

I do not have this problem if the tablespace is created without UNIFORM, i.e. autoallocate.

Solaris 9 / Oracle 9.2.0.4.0 64-bit

Thanks,

Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337


************************************************************************
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to [Email address protected]

Oracle LazyDBA home page