
/*************************************************************************/
/*************************************************************************/

CREATE TABLESPACE STORE_SPACE
LOGGING 
DATAFILE 'E:\MY_SPACE\STORE_DATA.ora' SIZE 50M 
REUSE   AUTOEXTEND 
ON NEXT  20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL 
SEGMENT SPACE MANAGEMENT  AUTO ;

/*************************************************************************/

CREATE TEMPORARY TABLESPACE STORE_TEMP TEMPFILE 
                    'E:\MY_SPACE\STORE_TEMP.ora' SIZE 20M 
REUSE   AUTOEXTEND 
ON NEXT  20M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL 
    UNIFORM SIZE 1M;

/*************************************************************************/
drop user inv cascade;

/*************************************************************************/
CREATE USER   inv   PROFILE DEFAULT 
    IDENTIFIED BY inv DEFAULT TABLESPACE STORE_SPACE
    TEMPORARY TABLESPACE STORE_TEMP
    ACCOUNT UNLOCK;

/*************************************************************************/
GRANT UNLIMITED TABLESPACE TO inv ;
GRANT CONNECT TO inv WITH ADMIN OPTION;
GRANT DBA TO inv WITH ADMIN OPTION;
commit;
