Skip to content

Instantly share code, notes, and snippets.

@bulain

bulain/create_tablespace.sql

Created March 31, 2012 06:53
Show Gist options
  • Save bulain/2260133 to your computer and use it in GitHub Desktop.
Save bulain/2260133 to your computer and use it in GitHub Desktop.
Download ZIP
create tablespace and user in oracle
Raw
create_tablespace.sql
create tablespace demos
logging
datafile '<path>/demo01.dbf'
size 256m
autoextend on
next 64m maxsize 2048m
extent management local;
CREATE USER demo
IDENTIFIED BY demo
DEFAULT TABLESPACE demos ;
GRANT connect,resource TO demo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment