Hi all,
Have a materialized view defined as refresh fast on commit:
CREATE MATERIALIZED VIEW mat_vw_name REFRESH FAST ON COMMIT WITH ROWID AS
Importing data to the table that is part of the mat view using SQL Loader. The query is taking a long time to process.
Do I need to perform anything after the bulk import is done? Is the mat view running after the bulk import?
Is there a way to see if any process is running in the background?
Thanks in advance.
Johnny
using: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit