--UNDOTBS
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF' SIZE 10M;

ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2;

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE
  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF' SIZE 4096M AUTOEXTEND OFF
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;

ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS1;

DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;

--DATA TABLESPACE
DROP TABLESPACE TS_AMLD INCLUDING CONTENTS AND DATAFILES;

CREATE TABLESPACE TS_AMLD DATAFILE
  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TS_AMLD_01' SIZE 2048M AUTOEXTEND OFF,
  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TS_AMLD_02' SIZE 2048M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

--INDEX TABLESPACE
DROP TABLESPACE TS_AMLI INCLUDING CONTENTS AND DATAFILES;

CREATE TABLESPACE TS_AMLI DATAFILE
  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TS_AMLI_01' SIZE 1024M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

--TEMP TABLESPACE
CREATE TEMPORARY TABLESPACE TMP
TEMPFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TMP01.DBF' SIZE 10M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TMP;

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
  'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP01' SIZE 1024M AUTOEXTEND OFF
TABLESPACE GROUP ''
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

DROP TABLESPACE TMP INCLUDING CONTENTS AND DATAFILES;

--USER
DROP USER AML CASCADE;

CREATE USER AML
  IDENTIFIED BY AML
  DEFAULT TABLESPACE TS_AMLD
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 3 Roles for AML
  GRANT RESOURCE TO AML;
  GRANT CONNECT TO AML;
  GRANT DBA TO AML;
  ALTER USER AML DEFAULT ROLE ALL;
  -- 5 System Privileges for AML
  GRANT CREATE DATABASE LINK TO AML;
  GRANT CREATE SYNONYM TO AML;
  GRANT CREATE PROCEDURE TO AML;
  GRANT CREATE VIEW TO AML;
  GRANT UNLIMITED TABLESPACE TO AML;