-
Tablespace Issue - Urgent...
Dear Gurus,
Just now i have created one tablespace like
SQL> create tablespace fin_users
2 datafile '/proddb/oracle/findata/find01.dbf' size 400m
3 extent management local autoallocate;
After creating my tablespace i use following command
select tablespace_name,extent_management,allocation_type from
dba_tablespaces;
FIN_USERS LOCAL SYSTEM
Can u please explain ALLOCATION_TYPE - SYSTEM means what?
I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.
Please explain ALLOCATION_TYPE - SYSTEM means what?
Thanks in advance,
Iyyappan.M
-
Re: Tablespace Issue - Urgent...
Originally posted by iyyappan
Can u please explain ALLOCATION_TYPE - SYSTEM means what?
I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.
Please explain ALLOCATION_TYPE - SYSTEM means what?
When Oracle manages extent allocation when we define as 'AUTOALLOCATE', allocation_type column shows 'SYSTEM'. If we define our own UNIFORM SIZE then the column shows as 'UNIFORM', if the tablespace is of type DICTIONARY, then column contains 'USER'
Sameer
Last edited by Sameer; 12-11-2002 at 04:43 AM.
-
Re: Tablespace Issue - Urgent...
Check Note:93771.1 on Metalink.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
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
|