Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Import will fail to create Materialized view. You need to follow these steps to fix it.

Code Block
languagesql
themeRDark
titleFix materialized view
DROP table FD.VAPPLICATIONSTATISTICS;

-- find CREATE MATERIALIZED VIEW FD.VAPPLICATIONSTATISTICS from FDOracleGenerateProcedures.sql and execute it.
-- now grant permissions

grant SELECT on FD.VAPPLICATIONSTATISTICS to FD_ADMIN;

...