Working as the SYS User
SYS has a schema (by the same name) and has lots of structures belonging to his account. You can connect (log in) to a database as
SYS, but a unique requirement of that user is that you have to specify that you are using the
SYSDBA privilege. (Note that in the text I will be using all uppercase for reserved words in Oracle commands and for default Oracle users, schemas, and structures.)
CONNECT sys AS sysdba;
At that point, you will have to enter the password associated with the
Note You can find a script of the following commands in the file named Chapter2/Sys.sql.
SYSDBA is a unique system ...