Skip to Content
avatar image
Former Member

adding data file with out using brtools /sapdba

Hi all,

How to add data file to table spaces with out using brtools /sapdba.Please let meknow.

Satya.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 09, 2008 at 09:53 AM
    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2008 at 10:02 AM

    If your database is oracle, you can use the alter tablespace command directly from sqlplus. But, why is the requirement to bypass brtools? That is the easy way of doing it.

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2008 at 10:07 AM

    why would you do that? whats your requirement?

    You can use sql commands (I prefer doing it via brtools),

    example

    alter tablespace <name of the tablespace> add datafile '<path of the datafile>' size <size in Mb>M autoextend <on/off> next <size> maxsize <size>;

    regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded