SQL Performance (MOSC)

MOSC Banner

creating materialized view takes long time

CREATE MATERIALIZED VIEW BOG_WEB_SERVICE.GP_MV_MY_CASES

    (CASE_ID,DIVISION_ID,DIVISION_NAME,RECEIVE_DIVISION_ID,RECEIVE_DIVISION_NAME,

    CASE_NO,REG_DATE,REG_YEAR_H,DIVISION_COURT_TYPE,DIVISION_COURT_TYPE_NAME,

    PLAINTIFFS,DEFENDANT,RECEIVE_DATE,IS_ARCHIVED_CASE,IDENTITY_TYPE_ID,

    IDENTITY_TYPE_NAME,GOV_ENTITY_ID,IDENTITY_ID,MASTER_GOV_ENTITY_ID,PARTY_ID,

    FULLNAME,FIRSTNAME,FATHERNAME,FATHERNAME1,FATHERNAME2,

    LASTNAME,PHONE1,PARTY_TYPE_ID,PARTY_TYPE_NAME,PARTY_KIND,

    KIND_TYPE,RULING_DATE,RULING_DELIVERY_DATE,CATEGORY_ID,CATEGORY_NAME,

    LAST_SESSION_DATE,HAS_ACT)

TABLESPACE USERS

PCTUSED   0

PCTFREE   10

INITRANS  2

MAXTRANS  255

STORAGE   (

           INITIAL         64K

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center