| General |
| Note |
This page is the setup for
examples in Morgan's Library. It gives the syntax for creating the
library's default tablespace and user.
For university of Washington students use
|
| |
| University of
Washington Setup |
Change Schema |
conn / as sysdba
CREATE TABLESPACE uwdata
DATAFILE 'C:\ORACLE\ORADATA\ORABASE\UWDATA01.DBF' SIZE 250M
LOGGING FORCE LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER uwclass
IDENTIFIED BY uwclass
DEFAULT TABLESPACE uwdata
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX
QUOTA UNLIMITED ON uwdata;
GRANT create session TO uwclass;
GRANT create cluster TO uwclass;
GRANT create database link TO uwclass;
GRANT create operator TO uwclass;
GRANT create procedure TO uwclass;
GRANT create sequence TO uwclass;
GRANT create synonym TO uwclass;
GRANT create table TO uwclass;
GRANT create trigger TO uwclass;
GRANT create type TO uwclass;
GRANT create view TO uwclass;
conn uwclass/uwclass |
| |
| SQL University
Setup |
Change Schema |
conn / as sysdba
CREATE TABLESPACE uwdata
DATAFILE 'C:\ORACLE\ORADATA\ORABASE\UWDATA01.DBF' SIZE 250M
LOGGING FORCE LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K
SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER sqlu
IDENTIFIED BY sqlu
DEFAULT TABLESPACE uwdata
TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA 0 ON SYSAUX
QUOTA UNLIMITED ON uwdata
QUOTA 10M ON example
QUOTA 10M ON users;
GRANT create session TO sqlu;
GRANT create cluster TO sqlu;
GRANT create database link TO sqlu;
GRANT create operator TO sqlu;
GRANT create procedure TO sqlu;
GRANT create sequence TO sqlu;
GRANT create synonym TO sql;
GRANT create table TO sqlu;
GRANT create trigger TO sqlu;
GRANT create type TO sqlu;
GRANT create view TO sqlu;
conn sqlu/sqlu |
| |
| All Students |
Change Schema |
CREATE TABLE
airplanes: Click Here
CREATE TABLE all_objs AS
SELECT * FROM all_objects;
Create the servers and serv_inst tables: Click
Here |