what is 1-connect /as sysdba, 2- set termout on ,3- shutdown and startup stands for. is sysdba same as connect to sys? what is the requirement of shutdown and startup . is it implicitly raises.

hi samarendra,

1- connect /as sysdba means that you would connect to the database as sysdba and will have the privelleges of DBA ...which are more than that of a user..

3- shutdown/startup stand for dismounting/mounting of the database on the server....if once shutdown you cant access the database from SQL*plus tool
you need to startup that is mount the database on the server which you can do as sysdba only...if you are not able to mount the database from SQL*plus tool then you can do it through enterprise manager in oracle but only when you log in to the instance as sysdba

2-? i also dont know about this 'set termout on' will try n answer it after a few days

2) what is 'set termout on' ?
Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.
For example, if "set termout off" is given, it will suppress the output of the sql commands and to revert it back, "set termout on" is used.

__________________
*** Innila ***

Thanks AARDVAX AND INNILA,

but why on earth is need for shutdown and startup commnd . you can logut simply. is it necessary .

and innila i am sorry , but i did not get it clearly about set termout plz if u can details about it . if possible with an example.

any way thanks again to both of u.

regards samarendra mishra

hi samarendra

if you are accessing server as one of the user you do not need to use startup (mounting) the database / shutdown (dismounting) the database..

as collection of objects in your schema needs not to be dismounted for you as one of the user....it is more usefull for the DBA who has access to all schemas...

for you as a user there is no need to use the above set of commands....but there may be a requirement of using the commands (whose usage u already know) by the administrator while making some changes in the structure..

hope that would solve your problem

well i also cound not understand the use of set termout on/off explained by INNILA...i tried putting that off while executing an SQL script but there was no change in the output...please clarify if you people come across any thing beneficial

thanks & regards

Hi,

Since the definition alone is not very much clear, let me explain with an example in detail.
As already given, Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.

Let me create a sql file named samplescript.sql since termout works for sql scripts.
The samplescript.sql consists of a simple query,
select empno, ename from emp;

Now, let me run the script by setting termout as on
Note :- Default value for termout is "on"


SQL> set termout on
SQL> @samplescript;

EMPNO EMPNAME
------------ -----------------
25398 STEVE

1 row selected.

This is the output of the script file, check out for the output while running the same sql file with termout "off"

SQL> set termout off
SQL> @samplescript;
SQL>


The output is not displayed or lets say, the output is suppressed since the setting of termout is off.
If there is a requirement where u want to run a sql script but avoid the output, then u can go for termout off.

Hope it is clear now.

__________________
*** Innila ***