|
-
[QUOTE]Originally posted by Turin
[B]Thanks all of you again.
Yes, I'm pretty sure that I have only one segment of 64 Kb.
The next extent's size (the 2nd) will have a size of 64 Kb according with the Oracle's storage formula for LMT AUTO ALLOC.
My free space, according white dba_free_space view, is 156,578125 Mb.
So, I think there aren't any reason for expecting lack of space in my LMT.
you may want to check how did you create your tablespace.
I just got exactly the same mesage on testing system - 9.2 gave me the same message during creation of simple table with blob column on the tablspace created as:
CREATE TABLESPACE CMM2_TSP_TBL03 LOGGING DATAFILE '/oracle_dbf1/oradata/ENKLAV/t
bl3_1.dbf' SIZE 1999M REUSE AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K;
Databases`s block size is 16K. It works on tablespace created as just 'MANAGEMENT LOCAL' and 'MANAGEMENT LOCAL UNIFORM SIZE 128K SEGMENT SPACE MANAGEMENT AUTO'.
I did not have time to check the reason of it yet, probably it`s supposed to be so...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|