Subject: CONFIRMED: Re: datafile
> The basic syntax is:
> 
> ALTER TABLESPACE tablespace
>     { ADD DATAFILE { filespec
>                      [AUTOEXTEND [ OFF
>                                  | ON [NEXT integer [K|M]]
>                                       [MAXSIZE {UNLIMITED | integer[K|M] ]
>                      [, filespec ...] }
> 
> So, an easy example is:
> 
> ALTER TABLESPACE TEMP ADD DATAFILE '/u01/oradata/PROD/temp01.dbf'
> SIZE 500M;
> 
> The AUTOEXTEND will allow the datafile to grow automatically if more space
> is needed within the tablespace. NEXT will determine how large each new
> growth of the datafile should be.
> 
> Best regards,
> 
> -Ari Kaplan
> www.arikaplan.com

Back to Ari Kaplan's Home Page