Canceling a Cache Refresh that Is Using Native or Parallel Loading
You can cancel a cache refresh process for parallel loading or Netezza.
Note: For Oracle using native loading, the cache refresh process runs to completion; it cannot be stopped after it is started. TDV cleans up the temporary tables automatically.
To cancel a cache refresh process for parallel loading or Netezza
1. Cancel the read request process that has started against the source view.
2. For parallel loading processes, you can cancel the parent request or cancel any of the threads to have the job canceled for all threads.