alter TABLESPACE <tbsp> ADD DATAFILE '<datafile>' size <nM> ..........

[Former Member]

Dear experts/Guru

Please let me know given below command use, how it works:

  alter TABLESPACE <tbsp> ADD DATAFILE '<datafile>' size <nM> REUSE AUTOEXTEND ON NEXT <nM> MAXSIZE <nM>

[Former Member · Accepted solution]

It basically add a data file to a tablespace.  

You will need to run this command as a user with DBA privileges. 

[Former Member · Accepted solution]

what is meaning of this:  REUSE AUTOEXTEND ON NEXT <nM> MAXSIZE <nM>

[stefan_koehler · Accepted solution]

Hello Sumit,

please check the oracle documentation: http://docs.oracle.com/cd/E11882_01/server.112/e26088/clauses004.htm#SQLRF01602

It is explained  very well ...

Regards

Stefan

[Former Member · Accepted solution]

Hi,

It means the you are allowing the datafile to be re used and should grow with mentioned next extent size and it should grow till specified Max size.

Regards,

Venkata S Pagolu.

[former_member182034]

hi Sumit,

please have look on following SAP link.

Alter Tablespace Syntax

Adding, Dropping, Rebalancing Tablespace

Regards,