Create the following Simphony Oracle Database Tablespaces on the database server or servers:
/* MCRSPOS */
DECLARE
CURSOR mcrspos_tablespace_check IS
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name = 'MCRSPOS';
CURSOR mcrspos_platform_check_w IS
SELECT substr(platform_name, 1, 9)
FROM gv$database;
CURSOR mcrspos_platform_check_l IS
SELECT substr(platform_name, 1, 5)
FROM gv$database;
CURSOR mcrspos_rac_check IS
select value from gv$parameter
where name = 'cluster_database';
CURSOR mcrspos_asm_check IS
select substr(file_name, 1,1)
from dba_data_files;
v_tablespace VARCHAR2(40);
v_path VARCHAR2(100);
sql_stmt VARCHAR2(10000);
v_platform_w VARCHAR2(40);
v_platform_l VARCHAR2(40);
v_rac VARCHAR2(10);
v_asm VARCHAR2(10);
BEGIN
OPEN mcrspos_tablespace_check;
OPEN mcrspos_platform_check_w;
OPEN mcrspos_platform_check_l;
OPEN mcrspos_rac_check;
OPEN mcrspos_asm_check;
FETCH mcrspos_tablespace_check INTO v_tablespace;
FETCH mcrspos_platform_check_w INTO v_platform_w;
FETCH mcrspos_platform_check_l INTO v_platform_l;
FETCH mcrspos_rac_check INTO v_rac;
FETCH mcrspos_asm_check INTO v_asm;
IF mcrspos_tablespace_check%NOTFOUND AND v_platform_w = 'Microsoft' THEN
SELECT substr(file_name, 1,((instr(file_name, '\', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrspos_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac <> 'TRUE' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrspos_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '+' THEN
sql_stmt := 'CREATE TABLESPACE MCRSPOS DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ENCRYPTION USING ''AES256'' DEFAULT NOCOMPRESS STORAGE(ENCRYPT) SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrspos_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '/' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
END IF;
END IF;
END IF;
END IF;
CLOSE mcrspos_tablespace_check;
CLOSE mcrspos_platform_check_w;
CLOSE mcrspos_platform_check_l;
CLOSE mcrspos_rac_check;
CLOSE mcrspos_asm_check;
END;
/
/* MCRSCACHE */
DECLARE
CURSOR mcrscache_tablespace_check IS
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name = 'MCRSCACHE';
CURSOR mcrscache_platform_check_w IS
SELECT substr(platform_name, 1, 9)
FROM gv$database;
CURSOR mcrscache_platform_check_l IS
SELECT substr(platform_name, 1, 5)
FROM gv$database;
CURSOR mcrscache_rac_check IS
select value from gv$parameter
where name = 'cluster_database';
CURSOR mcrscache_asm_check IS
select substr(file_name, 1,1)
from dba_data_files;
v_tablespace VARCHAR2(40);
v_path VARCHAR2(100);
sql_stmt VARCHAR2(10000);
v_platform_w VARCHAR2(40);
v_platform_l VARCHAR2(40);
v_rac VARCHAR2(10);
v_asm VARCHAR2(10);
BEGIN
OPEN mcrscache_tablespace_check;
OPEN mcrscache_platform_check_w;
OPEN mcrscache_platform_check_l;
OPEN mcrscache_rac_check;
OPEN mcrscache_asm_check;
FETCH mcrscache_tablespace_check INTO v_tablespace;
FETCH mcrscache_platform_check_w INTO v_platform_w;
FETCH mcrscache_platform_check_l INTO v_platform_l;
FETCH mcrscache_rac_check INTO v_rac;
FETCH mcrscache_asm_check INTO v_asm;
IF mcrscache_tablespace_check%NOTFOUND AND v_platform_w = 'Microsoft' THEN
SELECT substr(file_name, 1,((instr(file_name, '\', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSCACHE LOGGING DATAFILE ' || '''' || v_path || 'MCRSCACHE01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrscache_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac <> 'TRUE' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSCACHE LOGGING DATAFILE ' || '''' || v_path || 'MCRSCACHE01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrscache_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '+' THEN
sql_stmt := 'CREATE TABLESPACE MCRSCACHE DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ENCRYPTION USING ''AES256'' DEFAULT NOCOMPRESS STORAGE(ENCRYPT) SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
ELSE
IF mcrscache_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '/' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSCACHE LOGGING DATAFILE ' || '''' || v_path || 'MCRSCACHE01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
END IF;
END IF;
END IF;
END IF;
CLOSE mcrscache_tablespace_check;
CLOSE mcrscache_platform_check_w;
CLOSE mcrscache_platform_check_l;
CLOSE mcrscache_rac_check;
CLOSE mcrscache_asm_check;
END;
/
/* MCRSPOS_PAR */
DECLARE
CURSOR mcrspos_par_tablespace_check IS
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name = 'MCRSPOS_PAR';
CURSOR mcrspos_par_platform_check_w IS
SELECT substr(platform_name, 1, 9)
FROM gv$database;
CURSOR mcrspos_par_platform_check_l IS
SELECT substr(platform_name, 1, 5)
FROM gv$database;
CURSOR mcrspos_par_rac_check IS
select value from gv$parameter
where name = 'cluster_database';
CURSOR mcrspos_par_asm_check IS
select substr(file_name, 1,1)
from dba_data_files;
v_tablespace VARCHAR2(40);
v_path VARCHAR2(100);
sql_stmt VARCHAR2(10000);
sql_stmt2 VARCHAR2(10000);
v_platform_w VARCHAR2(40);
v_platform_l VARCHAR2(40);
v_rac VARCHAR2(10);
v_asm VARCHAR2(10);
BEGIN
OPEN mcrspos_par_tablespace_check;
OPEN mcrspos_par_platform_check_w;
OPEN mcrspos_par_platform_check_l;
OPEN mcrspos_par_rac_check;
OPEN mcrspos_par_asm_check;
FETCH mcrspos_par_tablespace_check INTO v_tablespace;
FETCH mcrspos_par_platform_check_w INTO v_platform_w;
FETCH mcrspos_par_platform_check_l INTO v_platform_l;
FETCH mcrspos_par_rac_check INTO v_rac;
FETCH mcrspos_par_asm_check INTO v_asm;
IF mcrspos_par_tablespace_check%NOTFOUND AND v_platform_w = 'Microsoft' THEN
SELECT substr(file_name, 1,((instr(file_name, '\', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_PAR LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_PAR ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_par_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac <> 'TRUE' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_PAR LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_PAR ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_par_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '+' THEN
sql_stmt := 'CREATE TABLESPACE MCRSPOS_PAR DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_PAR ADD DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_par_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '/' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_PAR LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_PAR ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_PAR02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
END IF;
END IF;
END IF;
END IF;
CLOSE mcrspos_par_tablespace_check;
CLOSE mcrspos_par_platform_check_w;
CLOSE mcrspos_par_platform_check_l;
CLOSE mcrspos_par_rac_check;
CLOSE mcrspos_par_asm_check;
END;
/
/* MCRSPOS_NDX */
DECLARE
CURSOR mcrspos_ndx_tablespace_check IS
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name = 'MCRSPOS_NDX';
CURSOR mcrspos_ndx_platform_check_w IS
SELECT substr(platform_name, 1, 9)
FROM gv$database;
CURSOR mcrspos_ndx_platform_check_l IS
SELECT substr(platform_name, 1, 5)
FROM gv$database;
CURSOR mcrspos_ndx_rac_check IS
select value from gv$parameter
where name = 'cluster_database';
CURSOR mcrspos_ndx_asm_check IS
select substr(file_name, 1,1)
from dba_data_files;
v_tablespace VARCHAR2(40);
v_path VARCHAR2(100);
sql_stmt VARCHAR2(10000);
sql_stmt2 VARCHAR2(10000);
v_platform_w VARCHAR2(40);
v_platform_l VARCHAR2(40);
v_rac VARCHAR2(10);
v_asm VARCHAR2(10);
BEGIN
OPEN mcrspos_ndx_tablespace_check;
OPEN mcrspos_ndx_platform_check_w;
OPEN mcrspos_ndx_platform_check_l;
OPEN mcrspos_ndx_rac_check;
OPEN mcrspos_ndx_asm_check;
FETCH mcrspos_ndx_tablespace_check INTO v_tablespace;
FETCH mcrspos_ndx_platform_check_w INTO v_platform_w;
FETCH mcrspos_ndx_platform_check_l INTO v_platform_l;
FETCH mcrspos_ndx_rac_check INTO v_rac;
FETCH mcrspos_ndx_asm_check INTO v_asm;
IF mcrspos_ndx_tablespace_check%NOTFOUND AND v_platform_w = 'Microsoft' THEN
SELECT substr(file_name, 1,((instr(file_name, '\', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_NDX LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_NDX ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_ndx_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac <> 'TRUE' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_NDX LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_NDX ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_ndx_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '+' THEN
sql_stmt := 'CREATE TABLESPACE MCRSPOS_NDX DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_NDX ADD DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_ndx_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '/' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_NDX LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_NDX ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_NDX02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
END IF;
END IF;
END IF;
END IF;
CLOSE mcrspos_ndx_tablespace_check;
CLOSE mcrspos_ndx_platform_check_w;
CLOSE mcrspos_ndx_platform_check_l;
CLOSE mcrspos_ndx_rac_check;
CLOSE mcrspos_ndx_asm_check;
END;
/
/* MCRSPOS_LOB */
DECLARE
CURSOR mcrspos_lob_tablespace_check IS
SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name = 'MCRSPOS_LOB';
CURSOR mcrspos_lob_platform_check_w IS
SELECT substr(platform_name, 1, 9)
FROM gv$database;
CURSOR mcrspos_lob_platform_check_l IS
SELECT substr(platform_name, 1, 5)
FROM gv$database;
CURSOR mcrspos_lob_rac_check IS
select value from gv$parameter
where name = 'cluster_database';
CURSOR mcrspos_lob_asm_check IS
select substr(file_name, 1,1)
from dba_data_files;
v_tablespace VARCHAR2(40);
v_path VARCHAR2(100);
sql_stmt VARCHAR2(10000);
sql_stmt2 VARCHAR2(10000);
v_platform_w VARCHAR2(40);
v_platform_l VARCHAR2(40);
v_rac VARCHAR2(10);
v_asm VARCHAR2(10);
BEGIN
OPEN mcrspos_lob_tablespace_check;
OPEN mcrspos_lob_platform_check_w;
OPEN mcrspos_lob_platform_check_l;
OPEN mcrspos_lob_rac_check;
OPEN mcrspos_lob_asm_check;
FETCH mcrspos_lob_tablespace_check INTO v_tablespace;
FETCH mcrspos_lob_platform_check_w INTO v_platform_w;
FETCH mcrspos_lob_platform_check_l INTO v_platform_l;
FETCH mcrspos_lob_rac_check INTO v_rac;
FETCH mcrspos_lob_asm_check INTO v_asm;
IF mcrspos_lob_tablespace_check%NOTFOUND AND v_platform_w = 'Microsoft' THEN
SELECT substr(file_name, 1,((instr(file_name, '\', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_LOB LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_LOB ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_lob_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac <> 'TRUE' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_LOB LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_LOB ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_lob_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' and v_asm = '+' THEN
sql_stmt := 'CREATE TABLESPACE MCRSPOS_LOB DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_LOB ADD DATAFILE ''+DATA'' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
ELSE
IF mcrspos_lob_tablespace_check%NOTFOUND AND v_platform_l = 'Linux' AND v_rac = 'TRUE' AND v_asm = '/' THEN
SELECT substr(file_name, 1,((instr(file_name, '/', - 1, 1)))) INTO v_path FROM dba_data_files WHERE ROWNUM < 2;
sql_stmt := 'CREATE TABLESPACE MCRSPOS_LOB LOGGING DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB01.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO';
EXECUTE IMMEDIATE sql_stmt;
sql_stmt2 := 'ALTER TABLESPACE MCRSPOS_LOB ADD DATAFILE ' || '''' || v_path || 'MCRSPOS_LOB02.dbf' || '''' || ' SIZE 512M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED';
EXECUTE IMMEDIATE sql_stmt2;
END IF;
END IF;
END IF;
END IF;
CLOSE mcrspos_lob_tablespace_check;
CLOSE mcrspos_lob_platform_check_w;
CLOSE mcrspos_lob_platform_check_l;
CLOSE mcrspos_lob_rac_check;
CLOSE mcrspos_lob_asm_check;
END;
/