The auto_refresh_external_table clause is used to periodically refresh the external table's meta data.
Syntax
DBMS_EXTERNAL_TABLE.auto_refresh_external_table(interval int)
Parameters
Parameter |
Note |
|---|---|
| interval int | Specifies the time interval for refreshing tasks. The value range is [-1, ∞], in seconds.
|
Examples
Run the following command to disable scheduled refresh tasks.
obclient> CALL DBMS_EXTERNAL_TABLE.auto_refresh_external_table(-1);
Query OK, 0 rows affected (0.104 sec)