-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path3dspace-r2018x.sql
11 lines (11 loc) · 1.54 KB
/
3dspace-r2018x.sql
1
2
3
4
5
6
7
8
9
10
11
create user M1 identified by M1;
grant connect, resource, create view to M1;
CREATE SMALLFILE TABLESPACE "M1" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\M1.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
ALTER USER M1 default tablespace M1;
GRANT UNLIMITED TABLESPACE TO M1;
CREATE SMALLFILE TABLESPACE "I1_DATA" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\I1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "I1_INDEX" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\I1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "M1_DATA" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\M1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "M1_INDEX" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\M1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "V1_DATA" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\V1_DATA.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE SMALLFILE TABLESPACE "V1_INDEX" LOGGING DATAFILE 'C:\oracle12c\oradata\R2018X\V1_INDEX.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;