Database Administration (MOSC)

MOSC Banner

Question regarding auto extend tablespace

edited Sep 1, 2010 9:06AM in Database Administration (MOSC) 9 commentsAnswered
 This is my first time work with autoextend tablespace.

I created the following tablespace:

CREATE TABLESPACE "SIREPO" DATAFILE '/dsk01/oradata/sirepo01.dbf' SIZE 100M AUTOEXTEND ON MAXSIZE 10000M extent management local uniform size 5M segment space management auto;

Does this mean by tablespace can go to 10g the max?


I later added some more datafiles under this tablespace,

alter database datafile '/dsk01/oradata/sirepo02.dbf' autoextend on maxsize 10000M;
alter database datafile '/dsk01/oradata/sirepo03.dbf' autoextend on maxsize 10000M;
alter database datafile '/dsk01/oradata/sirepo04.dbf' autoextend on maxsize 10000M;

Does this mean each of the datafile within the tablespace will be able to autoextend up to 10G?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center