| Use of AUTOEXTEND with DataFiles [message #4778] |
Tue, 14 January 2003 07:19  |
Mark Grimshaw
Messages: 73
Registered: June 2002
|
Member |
|
|
Hello,
Could someone confirm that the statement below which creates a tablespace and a datafile means that when the size of the datafile is reached it is increased automatically by the Oracle DBMS? If so, by how much is it extended?
create tablespace MY_TABLESPACE datafile 'dbfile1' SIZE 100M AUTOEXTEND ON MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
Thanks,
Mark Grimshaw
|
|
|
|
| Re: Use of AUTOEXTEND with DataFiles [message #4785 is a reply to message #4778] |
Tue, 14 January 2003 15:05  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
yes, when dbfile1 needs space that exceeds the 100M allocated for the file, the file will increase in size if the space is available at the OS. The actually size that it will increase by, because it is not specified in the statement, it will use the next extent size which you can get from DBA_TABLESPACES
SELECT tablespace_name, next_extent
FROM dba_tablespaces
WHERE tablespace_name = 'MY_TABLESPACE';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
