Starting SQL Scripts Manually with SQLPLUS (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Starting SQL Scripts Manually with SQLPLUS

Use

You can use the Oracle program SQLPLUS to start the SQL scripts. However, this is not essential, because you can also start all scripts with the SAPDBA function Additional functions ® Execute SQL script. The scripts cssvg<DBSID>.sql , grants.sql and con<TSP>.sql cannot be used with this function because these scripts can contain SAPDBA-specific commands.

Procedure

Enter the following command, if necessary, to start a script with SQLPLUS:

sqlplus <uid</passwd>> @<script[.sql]>

The meaning of the parameters is:

<uid</passwd>> : user name and password of the Oracle DBA user. In the SAP standard system, this is system with password manager .

<script[.sql]> : Name of the SQL script you want to start.