Executing Oracle Scripts - Note 706927
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
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:
Enter value for sap_tablespace: psapsr3
Select the Tablespace, where the indexes for the GVD_* and ORA_* Tables should be created:
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.