Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Executing Oracle Scripts - Note 706927

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question