RDBPROD: How can I generate a generic Create Table Script From Oracle Rdb? (Doc ID 1125833.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

How can I create an SQL script from RMU/EXTRACT which can be used in Oracle RDBMS, for example to define a copy or look-a-like table?  Using the default of RMU/EXTRACT/ITEM=TABLE, the output includes references to DOMAINS, which are an extension in SQL for Rdb.

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