8.13 SDO_GEOR_ADMIN.listUnregisteredRDT
Format
SDO_GEOR_ADMIN.listUnregusteredRDT() RETURN SDO_STRING2_ARRAYSET;
Description
Lists the unregistered raster data tables (RDTs) defined in the current schema or in all the schemas in the database. An RDT is unregistered if no entries in the SYSDATA table refer to it.
Parameters
None.
Usage Notes
This function returns an array of comma-delimited list of RDTs. The list contains the following information:
-
Schema name (only if you are connected as a user with DBA role)
-
RDT name
If you execute this function as a user with DBA role, then the function lists the unregistered RDTs in all the schemas in the database. Otherwise, it only lists the unregistered RDTs in the current schema.
Examples
SELECT * FROM THE (SELECT SDO_GEOR_ADMIN.listUnregisteredRDT FROM DUAL); COLUMN_VALUE --------------------------------------------------------------------------------- SDO_STRING2_ARRAY('RDT_REGULAR_02')
Parent topic: SDO_GEOR_ADMIN Package Reference