Each row in the SYSMVOPTION system view describes the setting of one option value for a materialized view at the time of its creation. However, the description does not contain the option name for the option. The underlying system table for this view is ISYSMVOPTION.
|Column name||Column type||Column constraint|
|view_object_id||UNSIGNED BIGINT||NOT NULL|
|option_id||UNSIGNED INT||NOT NULL|
|option_value||LONG VARCHAR||NOT NULL|
view_object_id The object ID of the materialized view.
option_id A unique number identifying the option in the database. To see the option name, see the SYSMVOPTIONNAME system view.
option_value The value of the option at the time that the materialized view was created.
PRIMARY KEY (view_object_id, option_id)
FOREIGN KEY (view_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (option_id) references SYS.ISYSMVOPTIONNAME (option_id)