Skip to Content
avatar image
Former Member

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

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>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 21, 2012 at 03:20 PM

    It basically add a data file to a tablespace.  

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • Apr 21, 2012 at 06:38 PM

    hi Sumit,

    please have look on following SAP link.

    Alter Tablespace Syntax

    Adding, Dropping, Rebalancing Tablespace

    Regards,

    Add comment
    10|10000 characters needed characters exceeded