Function Oracle Allbase Suprtool Program /usr/oracle/bin/sqlplus /usr/bin/isql (HP-UX) /usr/robelle/suprtool and isql.pub.sys (MPE) Open Auto-connect upon entry or CONNECT TO 'DBEnv'; Open Oracle User Password or CONNECT [user/password] Open Allbase DBEnv Owner Close DISCONNECT RELEASE; RESET OPEN or subsequent OPEN command DB location Variables ORACLE_SID fully-qualified name in fully-qualified name in and ORACLE_HOME CONNECT statement OPEN statement pointing to init.ora file Security user/password on login name login name CONNECT or login name Default owner user name (owner aka schema) login name On OPEN, User with Oracle or Owner with Allbase Change default must re-connect SET OWNER owner; must re-open owner DBA SYSTEM user DBEnv creator Data Definition auto-commit active must COMMIT or ROLLBACK Language(DDL) transaction then commit DDL immediately Commit Work auto-commit on exit must COMMIT or ROLLBACK. Confirm on exit System info USERS_, DBA_, ALL_ Views with SYSTEM or tables and views CATALOG owner Table/view layout DESCRIBE INFO FORM Physical files DATAFILE DBEFILE Logical space TABLESPACE DBEFILESET Command file names if no extension, no convention no convention defaults to ".sql" Execute command START filename or START filename; USE filename file @filename Execute previous / DO DO command Modify previous CHANGE REDO (MPE-style, will REDO (MPE-style) or command execute) BEFORE (will execute) List previous LIST LIST HISTORY @; LISTREDO command(s) Exit program EXIT or QUIT EXIT or END EXIT