auto_refresh_external_table is used to periodically refresh the metadata of an external table.
Syntax
DBMS_EXTERNAL_TABLE.auto_refresh_external_table(interval int)
Parameters
Parameter |
Description |
|---|---|
| interval int | The time interval for the refresh task, in seconds. The value ranges from -1 to infinity.
|
Examples
Execute the following command to disable the periodic refresh task.
obclient> CALL DBMS_EXTERNAL_TABLE.auto_refresh_external_table(-1);
Query OK, 0 rows affected (0.104 sec)