Please read the users help file before starting this.
creating your directory
ssh to oracle@144.38.198.53 Password (Contact Bob)
LINUX> cd
LINUX> mkdir dir
Logging into Oracle
ssh to oracle@144.38.198.53 Password (Contact Bob)
LINUX> cd dir
LINUX> sqlplus
user: user
password: password
Running Oracle as sysdba
First Login to Oracle. The tablespace is sys and the user is sysdba (the Oracle root user).
sqlplus
user: sys as sysdba
password: (Contact Bob)
Starting / Shutting Down Oracle
First startup an Instance of Oracle.
SQL> startup (starts up an Oracle instance)
SQL> shutdown (shuts Oracle instance down)
Logging into Oracle as a user
First login to Oracle. The user name is name. The tablespace is ts_name. A tablespace is like a file folder that is used to store a collection of tables. The default tablespace is what is specified in the create user command. When Oracle is intalled a tablespace of SYS is created. The root user is SYSDBA.
sqlplus
user: name (uses default tablespace ts_name)
user: ts_name as user
password: password
Running a script in Oracle
A script is an Oracle program stored in a text file. Use .sql as the file extension.
SQL> @script.sql
Spooling the output of Oracle to a file (tee)
This redirects the output of sqlplus commands to a text file. Use .txt as the file extension.
SQL> spool file.txt