Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 03, 2008 at 05:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded