CA DataMinder provides Native Upgrade scripts for customers who require flexibility in managing the database for their Oracle CMS. For example, these scripts enable DBAs to use their own tablespace and partition naming conventions.
Important! Always use a version of SQL*Plus that matches your version of Oracle. Errors can occur if you use an older version of SQL*Plus to run scripts against a newer version of Oracle.
Find the Native Upgrade scripts in the CA DataMinder distribution image. Browse to the \Support\NativeSchemaSQL\ORACLE\Partitioned folder. This folder contains the following subfolders:
The scripts in this folder are for customers installing a new partitioned CMS. They are not needed when upgrading an existing Oracle CMS.
You need the scripts in this folder if you are upgrading a partitioned r12.0 CMS where the database is partitioned and/or you need to customize physical attributes of objects in the upgrade.
Note: After upgrading from 12.0, you must run a table partitioning stored procedure.
You need the scripts in this folder if you are upgrading a partitioned r12.5 CMS where the database is partitioned and/or you need to customize physical attributes of objects in the upgrade.
If you are upgrading from 12.0, these scripts comprise the second stage in the pre-upgrade process.
You need the scripts in this folder if you are upgrading a partitioned 14.0 CMS where the database is partitioned and/or you need to customize physical attributes of objects in the upgrade.
If you are upgrading from:
You need the scripts in this folder if you are upgrading a partitioned 14.1 CMS where the database is partitioned and/or you need to customize physical attributes of objects in the upgrade.
If you are upgrading from:
You need the scripts in this folder if you are upgrading a partitioned 14.5 CMS where the database is partitioned and/or you need to customize physical attributes of objects in the upgrade.
If you are upgrading from:
|
Copyright © 2014 CA.
All rights reserved.
|
|