changeset 2359:33062484cc56

Added explizit TABLESPACE definition for the user. flys-backend/trunk@3078 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Schilberg <bjoern@intevation.de>
date Tue, 25 Oct 2011 15:19:56 +0000
parents 441028ca9a28
children 9df06b88c079
files flys-backend/ChangeLog flys-backend/doc/schema/oracle_create_user.sql
diffstat 2 files changed, 11 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Tue Oct 25 06:52:32 2011 +0000
+++ b/flys-backend/ChangeLog	Tue Oct 25 15:19:56 2011 +0000
@@ -1,3 +1,8 @@
+2011-10-25  Bjoern Schilberg <bjoern.schilberg@intevation.de>
+
+	* doc/schema/oracle_create_user.sql:
+	  Added explizit TABLESPACE definition for the user.
+
 2011-10-25  Bjoern Schilberg <bjoern.schilberg@intevation.de>
 
 	* doc/schema/oracle_create_user.sql: 
--- a/flys-backend/doc/schema/oracle_create_user.sql	Tue Oct 25 06:52:32 2011 +0000
+++ b/flys-backend/doc/schema/oracle_create_user.sql	Tue Oct 25 15:19:56 2011 +0000
@@ -1,8 +1,11 @@
+--CREATE TABLESPACE for user
+CREATE TABLESPACE "test" DATAFILE '/u01/app/oracle/oradata/XE/test.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE 1G LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
+--CREATE USER
 CREATE USER test IDENTIFIED BY test;
 -- USER SQL
-ALTER USER test DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
--- QUOTAS
-ALTER USER test QUOTA UNLIMITED ON USERS;
+ALTER USER test DEFAULT TABLESPACE test TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
+-- QUOTA for user on TABLESPACE
+ALTER USER test QUOTA UNLIMITED ON test;
 GRANT ALL on "MDSYS"."ALL_SDO_GEOM_METADATA" to test ;
 GRANT CREATE SESSION TO test ;
 GRANT CREATE VIEW TO test;

http://dive4elements.wald.intevation.org