How do I use SQLPLUS?

Start SQLPLUS: admin@dbserver1:~$ /net/oracle/bin/sqlplus ‘dbserver1/ted@DBSP’ To add a user to Oracle Database: SQL> CREATE USER bob IDENTIFIED BY DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 2000m ON users QUOTA 0m ON system; User created. SQL> GRANT connect,resource TO bob; SQL> CONNECT bob; If you want bob to have DBA privileges as well, then: SQL> GRANT …

Continue reading ‘How do I use SQLPLUS?’ »