OATM tutorial Part 3 : Create New Tablespaces



Last updated on September 13th, 2015 at 05:45 pm

Create New Tablespaces

Now we will need to create the new tablespace where data will be migrated
Oracle Applications Tablespace Migration Utility

Main Menu
1. Migration Sizing Reports
2. Create New Tablespaces
3. Generate Migration Commands
4. Execute Migration Commands
5. Run Migration Status Reports
6. Run Post Migration Steps
7. Run Customization Steps
8. Run Migration in Batch Mode

[Q]uit [N]ext

We need to choose Option -2

Create New Tablespace

1. Generate new tablespace creation script
2. Create new tablespaces

[Q]uit [B]ack [N]ext
We can choose either option 1 to create new tablespace script or directly create the tablespace using option 2
I personally prefer option 1 as in the generate script you can managed ,monitor and change whichever we way you like
So by choosing option 1

*****************************************************************
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 the Extent Allocation type A(utoallocate) or U(niform Extent Size)[U]: A ( This is algorithm for Extent allocation type which can be Autoaalocate or Uniform.)

Enter the absolute path for the datafiles directory: /xyz/oracle/DATA( This is path where all the datafiles would be stored))

Enter the Number of Datafiles for APPS_TS_TX_DATA tablespace[1]: 100
Enter the Datafile Size for APPS_TS_TX_DATA tablespace (MB): 10240

Note: The above two field are decided based on the sizing requirement for the tablespace we have got from about migration sizing report.
Enter the Number of Datafiles for APPS_TS_TX_DATA tablespace: This is the number of database we are creating based on size of each datafile.
Support we need to create 1TB of APPS_TS_TX_DATA tablespace as per migration sizing report.Now we are expecting the datafile size to be 10G.Then 100 files will be required
for tablespace.
Enter the Number of Datafiles for APPS_TS_TX_IDX tablespace[1]: 50
Enter the Datafile Size for APPS_TS_TX_IDX tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_SEED tablespace[1]: 1
Enter the Datafile Size for APPS_TS_SEED tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_INTERFACE tablespace[1]: 2
Enter the Datafile Size for APPS_TS_INTERFACE tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_SUMMARY tablespace[1]: 2
Enter the Datafile Size for APPS_TS_SUMMARY tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_NOLOGGING tablespace[1]: 2
Enter the Datafile Size for APPS_TS_NOLOGGING tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_ARCHIVE tablespace[1]: 2
Enter the Datafile Size for APPS_TS_ARCHIVE tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_QUEUES tablespace[1]: 5
Enter the Datafile Size for APPS_TS_QUEUES tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_MEDIA tablespace[1]: 5
Enter the Datafile Size for APPS_TS_MEDIA tablespace (MB): 10240
Enter the Number of Datafiles for APPS_TS_TOOLS tablespace[1]: 1
Enter the Datafile Size for APPS_TS_TOOLS tablespace (MB): 10240

Tablespace creation script
/xyz/oracle/xyzappl/admin/TEST/log/crtts.sql created

Here we are creating all the new tablespace which will be used for OATM migration.

 
All the related OATM material are

OATM lesson 1

Migration sizing report

Generate Migration commands

Execute Migration command


Leave a Reply