By default, SAP R3 4.7 has 6 tablespace. You can check them using tcode DB02. I already show you how to extend tablespace that already exist.
Now I want to show step by step adding new tablespace. I am going to use BRTOOLS, to add new tablespace. Open your MS-DOS prompt using user [sid]adm. Use ora[sid] user for your UNIX box.
To add new tablespace, choose option number 2 Space Management. Then ENTER.
Choose option number 2 to Create Tablespace. Then ENTER.
Enter option number 3 to propose tablespace name. Tablespace name must have prefix PSAPIDS (for my IDES box). Depend on your box. Here, I named it PSAPIDS_REORG (Coz I want to use it later for reorganization purpose).
After that, enter C then ENTER.
Tablespace creation is going to execute. You do not net to shutdown your SAP R3 nor Oracle DB to do this. You can do this online.
Additional information you need to supply such as datafile size, increment size, etc. Then type c to continue.
Tablespace creation is running. Wait for couple minutes.
Tablespace PSAPIDS_REORG has been created successfully. Type C to continue.
Back to Space Management menu. Next step, check the result using DB02 tcode.
You can see that tablespace PSAPIDS_REORG has been added in tablespace list.
Congratulations ! Now, you can continue your coffee break time :D…