/*
 * Title  : ggt.sql
 * Author : EXADIME LLC
 * Created: 26-Nov-2019
 * Updated: 26-Nov-2019
 * Release: 1.0.0
 * Purpose: To create Golden Gate Tablespace.
 * History: N/A
 */

start oracle.ini

accept p_dir char prompt 'Enter datafile directory: '

spool &&tmp_dir/ggt.log

create tablespace ggs
datafile '&&p_dir/ggs_01.dbf' size 1G autoextend on
extent management local autoallocate
segment space management auto;

spool off
