cancel
Showing results for 
Search instead for 
Did you mean: 

adding data file with out using brtools /sapdba

Former Member
0 Kudos

Hi all,

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

Satya.

Accepted Solutions (0)

Answers (3)

Answers (3)

JPReyes
Active Contributor
0 Kudos

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

0 Kudos

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.

Former Member
0 Kudos