Executing Oracle Scripts - Note 706927

[Former Member]

Hello,

We are running our BI system with Oracle database. To view all details in DBACOCKPIT we need to execute the script in the note 706927. I have few doubts when executing these scripts.

I have executed the scripts with command from <sid>adm user

SQLPLUS "/as sysdba" @create

later it prompted me to select sap_schema from the following list

USERNAME

-

---

OPS$BWDEV\SAPSERVICESR3

OPS$BWDEV\SAPSERVICEBWD

OPS$BWDEV\BWDADM

SYS

SYSTEM

SAPSR3

SAPSR3DB

OUTLN

TSMSYS

DIP

DBSNMP

I have selected SAPSR3 and entered with right password.

Now its prompting me to select tablespace

Select the Tablespace, where the GVD_* and ORA_* Tables should be created:

TABLESPACE_NAME

-

---

SYSTEM

PSAPUNDO

SYSAUX

PSAPTEMP

PSAPSR3

PSAPSR3700

PSAPSR3USR

PSAPSR3DB

Enter value for sap_tablespace: psapsr3

Tablespace: psapsr3

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Select the Tablespace, where the indexes for the GVD_* and ORA_* Tables should be created:

TABLESPACE_NAME

-

---

SYSTEM

PSAPUNDO

SYSAUX

PSAPTEMP

PSAPSR3

PSAPSR3700

PSAPSR3USR

PSAPSR3DB

Now my doubt is am i proceeding in right way. I am not sure about selecting table_space for creating table and index. Kindly let me now how should i proceed. Is there any notes for explaining this.

regards,

Madhu

[lbreddemann · Accepted solution]

Hi Madhu,

you can just choose the same tablespace for the indexes as for the tables.

The option to select different tablespaces was implemented just for systems where these two segment types are strictly put into different tablespaces as it has been common in the early oracle days.

KR Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your time and reply.

However i am not sure about the table space selected for creating the tables. I would like to know is this the right procedure that i am following?

Any idea on this.

regards,

Madhu

[lbreddemann · Accepted solution]

Hi Madhu,

actually it doesn't matter which tablespace you choose here.

It has to be one of the PSAPxxx tablespaces and not PSAPTEMP or PSAPUNDO...

For the use of the tables it makes no difference in which tablespace they are stored.

KR Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your reply. I have got some idea.

regards,

Madhu