CREATE TABLESPACE SIMS_DATA DATAFILE
'D:\oracle\oradata\ORA815\SIMS_DATA.dbf' SIZE 50M
AUTOEXTEND ON NEXT 5M DEFAULT STORAGE
( INITIAL 20K NEXT 30K MAXEXTENTS UNLIMITED PCTINCREASE 0 );
CREATE USER "JSIMS" IDENTIFIED BY "JSIMS" DEFAULT TABLESPACE "SIMS_DATA" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "JSIMS";
GRANT "RESOURCE" TO "JSIMS";
GRANT UNLIMITED TABLESPACE TO "JSIMS";
ALTER USER "JSIMS" DEFAULT ROLE ALL;
'D:\oracle\oradata\ORA815\SIMS_DATA.dbf' SIZE 50M
AUTOEXTEND ON NEXT 5M DEFAULT STORAGE
( INITIAL 20K NEXT 30K MAXEXTENTS UNLIMITED PCTINCREASE 0 );
CREATE USER "JSIMS" IDENTIFIED BY "JSIMS" DEFAULT TABLESPACE "SIMS_DATA" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT "CONNECT" TO "JSIMS";
GRANT "RESOURCE" TO "JSIMS";
GRANT UNLIMITED TABLESPACE TO "JSIMS";
ALTER USER "JSIMS" DEFAULT ROLE ALL;