-
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
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
|