6.107 SDO_NET.VALIDATE_PARTITION_SCHEMA
Format
SDO_NET.VALIDATE_PARTITION_SCHEMA( network IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the metadata relating to partitions in a network is valid; returns the string FALSE
if the metadata relating to partitions in a network is not valid.
Usage Notes
This function checks the validity of information in the partition table, which is described in Partition Table.
Examples
The following example checks the validity of the metadata related to partitions in the network named SDO_PARTITIONED
.
SELECT SDO_NET.VALIDATE_PARTITION_SCHEMA('SDO_PARTITIONED') FROM DUAL; SDO_NET.VALIDATE_PARTITION_SCHEMA('SDO_PARTITIONED') -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms