Download Oracle E-Business Suite System Administrator`s Guide

Option 1: Generate the Tablespace Creation Script
Option 1 prompts you for the extent allocation type, such as Autoallocate, Uniform
Extent, and Uniform Extent Size, which will be used for creating the new tablespaces.
The utility prompts for the name of the directory in which the datafile will be created.
For every tablespace created as part of OATM, the utility prompts you for information,
such as number and size of the datafiles. The utility will append a sequence number to
the tablespace name and a .dbf extension to generated the datafile name. For example, if
you enter the datafile directory as "/u01/oradata" and for transaction data tablespace,
APPS_TS_TX_DATA, you enter the number of datafiles as 2 and size as 2000M, the
utility will create tablespace creation script with 2 datafiles for the tablespace named
"/u01/oradata/APPS_TS_TX_DATA01.dbf" and
"/u01/oradata/APPS_TS_TX_DATA02.dbf", each of size 2000M. To create datafiles of
different sizes or in different locations, you must modify the generated script, crtts.sql.
If you do not have limited disk space, create all tablespaces with the estimated sizes
listed in report #1. This will eliminate the need to extend the tablespaces as the
migration proceeds. If you do not have enough disk space to create all the tablespaces
with the total size, use the estimated values in report #2 <Schema Name> for reference.
If your operating system has a limit on the size of a dbf file, ensure you enter a value
less than this when prompted.
Example
Enter the Extent Allocation type A(utoallocate) or U(niform Extent
Size)[U]:
*****************************************************************
The utility will append a sequence number to the tablespace name
and a .dbf extension to generate the datafile names.
Datafile size should not be greater than OS file size limit.
Please edit the generated script to change the file name/size
*****************************************************************
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
Enter
the
the
the
the
the
the
the
the
the
the
the
the
the
the
the
the
the
the
the
absolute path for the datafiles directory: /u01/oradata
Number of Datafiles for Transaction data tablespace[1]: 2
Datafile Size for Transaction data tablespace (MB): 2000
Number of Datafiles for Transaction index tablespace[1]: 2
Datafile Size for Transaction index tablespace (MB): 2000
Number of Datafiles for Reference tablespace[1]: 1
Datafile Size for Reference tablespace (MB): 2000
Number of Datafiles for Interface tablespace[1]: 1
Datafile Size for Interface tablespace (MB): 1700
Number of Datafiles for Summary tablespace[1]: 2
Datafile Size for Summary tablespace (MB): 2000
Number of Datafiles for Nologging tablespace[1]:
Datafile Size for Nologging tablespace (MB): 60
Number of Datafiles for Archive tablespace[1]:
Datafile Size for Archive tablespace (MB): 1400
Number of Datafiles for Queue tablespace[1]:
Datafile Size for Queue tablespace (MB): 150
Number of Datafiles for Media tablespace[1]:
Datafile Size for Media tablespace (MB): 2000
Option 2: Create New Tablespaces
Select option 2 to create new tablespaces by executing the script crtts.sql that was
3-16 Oracle E-Business Suite System Administrator's Guide - Configuration