AUTO_REFRESH_EXTERNAL_TABLE regularly refreshes the metadata of an external table.
Syntax
DBMS_EXTERNAL_TABLE.auto_refresh_external_table(interval int)
Parameters
Parameter |
Description |
|---|---|
| interval int | The interval for scheduling the refresh task, in seconds. Value range: [-1,∞].
|
Examples
Execute the following statement to disable scheduling of the refresh task:
obclient> CALL DBMS_EXTERNAL_TABLE.auto_refresh_external_table(-1);