31.4 SDO_TIN_PKG.DROP_DEPENDENCIES
Format
SDO_TIN_PKG.DROP_DEPENDENCIES( basetable IN VARCHAR2, col IN VARCHAR2);
Description
Drops the dependencies between a TIN block table and a specified base table and column.
Parameters
- basetable
-
Name of a base table that was specified (in the
basetable
parameter of the SDO_TIN_PKG.INIT function) when the TIN was initialized. - col
-
Name of a column in base table that was specified in the
basecol
parameter of the SDO_TIN_PKG.INIT function.
Usage Notes
This procedure truncates the TIN block table and removes the association between the block table and the base table and column combination.
After you execute this procedure, you can drop the TIN block table or associate the table with another base table and column combination. For more information, see the Usage Notes for the SDO_TIN_PKG.INIT function.
Examples
The following example drops the dependencies between a TIN block table and a base table and column named BASE and TIN, respectively.
. . . declare begin mdsys.sdo_tin_pkg.drop_dependencies('BASE', 'TIN'); end; /
Parent topic: SDO_TIN_PKG Package (TINs)