on 06-01-2008 7:53 AM
Here is a question in TADM51 Unit 1. My question is how to execute a correct SQL command, since both SQLPLUS and BR*Tools are not recommended in the explanation. Or I misunderstood the explanation totally? Please advise. Thanks.
Question: If you know the correct SQL command, it is recommended to call the command (for example, as seen in BR*Tools) from SQLPLUS to perform actions on the database.
Answer: False
Explanation: Using SQLPLUS is only necessary in rare cases, for example to execute scripts provided by SAP. Executing SQL commands seen in BRTools is dangerous, because BRTools usually perform additional actions and checks before and after executing the SQL command.
no, you mistunderstood....sap recommends to use brtools instead of sqlplus (because of the "additional actions" used by brtools)
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Some times when you execute an action via BR*tools you see a SQL command.
IMHO, what the phrase means is that it is dangerous to execute the shown command on SQLPLUS.
The reason is that BR*tools perform additional checks or actions.
For example, create a tablespace is a simple command that can be executed in SQLPLUS.
But, BR*tools not only create the tablespace, it will check if there is enough free space on the filesystem, it will check if the filename/path follows SAP recommendations, it will update the SAP data dictionary ....
none of the mentioned checks/actions are done if you use SQLPLUS alone, you risk to create inconsistencies on the SAP data dictionary, execute a command that may fail (but BR*tools would have found out that before executing it) etc
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.