RDBPROD: How to Change an Item's Datatype in Oracle CODASYL DBMS (Doc ID 91840.1)

Last updated on JULY 28, 2016

Applies to:

Oracle CODASYL DBMS - Version 4.0a and later
HP OpenVMS VAX
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

The purpose of this article is to describe and demonstrate the steps necessary to change the datatype of an existing item in an Oracle CODASYL DBMS database. The same steps can be used to change the length of an item, for instance from 5 characters to 10.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms