adding a datafile using brtools

[Former Member]

Hi ,

i am trying to add a datafile to a tablespace.But the problem i am facing is that when i am selecting the below option the same screen appears again.Now the current data file no. is 46 so the next number would be 47. So using brtools i try to add i am getting the same screen again.

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

select option 2 - Space management.> Then select 1 = Extend tablespace> 3 ~ Tablespace name (tablespace) ... []-->c

Options for extension of tablespace PSAPSRP (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SRP/sapdata6/srp_46/srp.data46]

2 * Last added file size in MB (lastsize) . [10000]

3 - New file to be added (file) ........... [/oracle/SRP/sapdata6/srp_47/srp.data47]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [10000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPSRP add datafile '/oracle/SRP/sapdata6/srp_47/srp.data47' size 1]

After this i am gettign this screen

Options for extension of tablespace PSAPSRP (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SRP/sapdata6/srp_46/srp.data46]

2 * Last added file size in MB (lastsize) . [10000]

3 - New file to be added (file) ........... [/oracle/SRP/sapdata6/srp_48/srp.data48]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [10000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPSRP add datafile '/oracle/SRP/sapdata6/srp_48/srp.data48' size 1]

I don know why is it not getting added.Thanks in advance .reques to give pointers.

[Former Member · Accepted solution]

I had read the help sap documentation.I followed the same instructions but still i am facing the issue.

[KayKa · Accepted solution]

Hi,

have you created the directories /oracle/SRP/sapdata6/srp_47 or /oracle/SRP/sapdata6/srp_48 ?

Sorry, not so familiar with brtools, but doing this with sql*plus you have create directories before adding the new datafile.

Have you test the displayed sql-statement alone with sql*plus ?

regards

Kay

[Former Member · Accepted solution]

Got my issue resolved i had to press no. Then the data file got created. Anyways thanks for your help.