34.2 SDO_WCS.DropTempTable

Format

SDO_WCS.DropTempTable(
     schema_name   IN VARCHAR2 DEFAULT USER); 

Description

Drops WCS temporary tables from a schema. (WCS Temporary tables are necessary for WCS GeoCoverage processing.)

Parameters

schema_name

Name of the database schema containing WCS temporary tables to be dropped. If not specified, the invoker's schema is used.

Usage Notes

If schema_name is not the invoking user, the invoking user must have privileges to drop tables from that schema.

For information about support for WCS, see Web Coverage Service (WCS) Support.

Examples

The following example drop WCS temporary tables from the invoker's schema.

BEGIN
SDO_WCS.DropTempTable();
END;

The following example drops WCS temporary tables from the SCOTT schema. The invoking user must have privileges to drop tables in the SCOTT schema.

BEGIN
SDO_WCS.DropTempTable(‘SCOTT’);
END;