ALTER DATABASE DEFAULT Temporary tablespace "SYSTEM"
ALTER DATABASE tempfile ' F:/oracle/product/10.1.0/oradata/orcl/temp01. DBF ' RESIZE 200M
ALTER DATABASE tempfile ' F:/oracle/product/10.1.0/oradata/orcl/temp01. DBF ' Autoextend off
CREATE bigfile tablespace "apptbl" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/apptbl01. DBF ' SIZE 1024M autoextend on NEXT 256M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' apptbl '); End;
CREATE USER Swifts profile default identified by Swifts default tablespace apptbl temporary TEMP;
GRANT "CONNECT" to "Swifts"
GRANT RESOURCE to Swifts;
ALTER USER ' Swifts ' QUOTA Unlimited on ' aotocre_tbl ' QUOTA Unlimited on ' apptbl ' QUOTA 0 K on ' basedata ' QUOTA unlimited O N "Batchdata" QUOTA Unlimited on "Query_tbl" QUOTA Unlimited on "TEMP"
ALTER USER "Swifts" QUOTA Unlimited on "Basedata" QUOTA Unlimited on "Indx_tbl"
CREATE bigfile tablespace "basedata" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/basedata01. DBF ' SIZE 2048M autoextend on NEXT 1024M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' basedata '); End;
CREATE bigfile tablespace "batchdata" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/batchdata01. DBF ' SIZE 4096M autoextend on NEXT 2048M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' batchdata '); End;
CREATE bigfile tablespace "query_tbl" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/query_tbl01. DBF ' SIZE 4096M autoextend on NEXT 1024M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' query_tbl '); End;
CREATE bigfile tablespace "aotocre_tbl" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/aotocre_tbl01. DBF ' SIZE 4096M autoextend on NEXT 1024M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' aotocre_tbl '); End;
CREATE bigfile tablespace "indx_def" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/indx_def01. DBF ' SIZE 4096M autoextend on NEXT 1024M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT space MANAGEMENT AUTO
BEGIN Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' indx_def '); End;
CREATE bigfile tablespace "indx_tbl" DataFile ' f:/oracle/product/10.1.0/oradata/orcl/indx_tbl01. DBF ' SIZE 4096M autoextend on NEXT 2048M MAXSIZE Unlimited LOGGING EXTENT MANAGEMENT local SEGMENT spaces MANAGEMENT AUTO Br>begin Dbms_server_alert. Set_threshold (9000,null,null,null,null,1,1,null,5, ' indx_tbl '); End;