CREATE TEMPORARY TABLESPACE ATS_TEMP TEMPFILE 'D:\Oracle11g\oradata\orcl\ATS_TEMP.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED; CREATE TABLESPACE ATS_PACS DATAFILE 'D:\Oracle11g\oradata\orcl\xxxx.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING ONLINE BLOCKSIZE 8K EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL; CREATE TABLESPACE ATS_AIGATE DATAFILE 'D:\oracle\product\10.2.0\db_1\oradata\orcl\xxxxx.DBF' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING ONLINE BLOCKSIZE 8K EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL; CREATE USER AIGATE IDENTIFIED BY AIGATE DEFAULT TABLESPACE ATS_AIGATE TEMPORARY TABLESPACE ATS_TEMP PROFILE DEFAULT; GRANT DBA TO AIGATE WITH ADMIN OPTION;