Adding an SRID to Spatial

A Norwegian version of this post can be found here .

Add SRID 5973 to Oracle Spatial

Oracle Spatial comes with over 6000 coordinate systems, but SRID 5973 is currently missing. However this is easy to add with a few insert-statements.

Run this as user SYSTEM:

insert into sdo_datums (
DATUM_ID,
DATUM_NAME,
DATUM_TYPE,
ELLIPSOID_ID,
PRIME_MERIDIAN_ID,
INFORMATION_SOURCE,
DATA_SOURCE,
SHIFT_X,
SHIFT_Y,
SHIFT_Z,
ROTATE_X,
ROTATE_Y,
ROTATE_Z,
SCALE_ADJUST,
IS_LEGACY,
LEGACY_CODE)
values (
1096,
'Norway Normal Null 2000',
'VERTICAL',
null,
null,
'Norwegian Mapping Authority',
'OGP',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
'FALSE',
NULL);

INSERT INTO sdo_coord_ref_system (
    srid,
    coord_ref_sys_name,
    coord_ref_sys_kind,
    coord_sys_id,
    datum_id,
    geog_crs_datum_id,
    source_geog_srid,
    projection_conv_id,
    cmpd_horiz_srid,
    cmpd_vert_srid,
    information_source,
    data_source,
    is_legacy,
    legacy_code,
    legacy_wktext,
    legacy_cs_bounds,
    is_valid,
    supports_sdo_geometry
)
VALUES (
    '5941',
    'NN2000 height',
    'VERTICAL',
    '6499',
    '5206',
    '5206',
    NULL,
    NULL,
    NULL,
    NULL,
    'Norwegian Mapping Authority.',
    'EPSG',
    'FALSE',
    NULL,
    NULL,
    NULL,
    'TRUE',
    'TRUE'
);

INSERT INTO sdo_coord_ref_system (
    srid,
    coord_ref_sys_name,
    coord_ref_sys_kind,
    coord_sys_id,
    datum_id,
    geog_crs_datum_id,
    source_geog_srid,
    projection_conv_id,
    cmpd_horiz_srid,
    cmpd_vert_srid,
    information_source,
    data_source,
    is_legacy,
    legacy_code,
    legacy_wktext,
    legacy_cs_bounds,
    is_valid,
    supports_sdo_geometry
) VALUES (
    '5973',
    'ETRS89 / UTM zone 33N + NN2000 height',
    'COMPOUND',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    '25833',
    '5941',
    'Norwegian Mapping Authority',
    'EPSG',
    'FALSE',
    NULL,
    NULL,
    NULL,
    'TRUE',
    'TRUE'
);

commit;