Format

SDO_WCS.CreateTempTable(
     schema_name      IN VARCHAR2 DEFAULT USER, 
     tablespace_name  IN VARCHAR2 DEFAULT NULL); 

Description

Creates temporary tables necessary during GetCoverage processing when reprojection or transformation is involved.

Parameters

schema_name

Name of the schema in which temporary tables will be created. If not specified, the tables are created in invoking user’s schema.

tablespace_name

Name of the tablespace for temporary tables. If not specified, the user's default tablespace is used.

Usage Notes

Each temporary GeoRaster object is stored in the same schema as the original GeoRaster object. When a GetCoverage Operation (WCS) response has been sent to the client, any temporary GeoRaster created during processing of a request is deleted.

This procedure must be invoked for all schemas whose GeoRaster objects will be published as coverages.

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

Examples

The following example creates WCS temporary tables in the invoker's schema.

CALL SDO_WCS.createTempTable();

The following example creates WCS temporary tables in the SCOTT schema. The invoking user must have privileges to create tables in the SCOTT schema.

CALL SDO_WCS.createTempTable(‘SCOTT’);