Home » Database Administration » Create New Tablespace on SAP R3 server using BRTOOLS

Create New Tablespace on SAP R3 server using BRTOOLS

RSS Link

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 690,237 hits


Categories

Advertisements

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…

Advertisements

2 Comments

  1. Kapil Kathuria says:

    Thanks for this wonderful posting!

  2. Omar says:

    Hello I have to create the following tablespaces :
    1. AEPR
    2. Anomalies
    3. Données de base
    4. Facturation
    5. Prestations
    6. Publication
    7. Recouvrement
    8. Relevé
    9. Switch Documents
    10. Générique

    Do I have to create one Index for every one ?
    Which sap tablespace convention name must I follow ?

    Regards,
    Omar

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

My twitter post @devratt

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

June 2008
M T W T F S S
« Dec   Jul »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Popularity


PageRank

Bookmark and Share

Top Clicks

  • None
%d bloggers like this: