RDBPROD: RDMS-F-MAPAREAINUSE when Creating Storage Maps (Doc ID 854261.1)

Last updated on JULY 29, 2016

Applies to:

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


Symptoms

The create storage map command:

create storage map table_1_map for table_1
   store  using (field_1,field_2)
       in STORAGE_AREA_ONE with limit of (10,10)
       in STORAGE_AREA_TWO with limit of (20,20)
       in STORAGE_AREA_ONE with limit of (30,30);

generates an error:

%RDB-E-NO_META_UPDATE, metadata update failed
-RDMS-F-MAPAREAINUSE, area STORAGE_AREA_ONE already specified for map TABLE_1_MAP in partition 0

The storage area STORAGE_AREA_ONE is used twice in the CREATE STORAGE MAP command.

Cause

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