I’m Not Interested in Oracle

SET ECHO ON
SET FEEDBACK ON

CREATE TABLESPACE [space1] SIZE 5M MAXSIZE 5M;
CREATE TABLESPACE [space2] SIZE 20M AUTOEXTEND ON NEXT 48K MAXSIZE 20M;
CREATE TABLESPACE [space3] SIZE 10M AUTOEXTEND OFF NEXT 128;

CREATE USER [user1]
IDENTIFIED BY [pass]
QUOTA 5M ON [space1]
QUOTA 500M ON [space2]
QUOTA 10M ON [space3]
DEFAULT TABLESPACE [space2]
GRANT RESOURCE, CONNECT, CREATE TABLE, CREATE VIEW TO [user1];

.

Leave a Reply

Your email address will not be published. Required fields are marked *