Question

  • Creator
    Topic
  • #2150570

    partition on snapshot

    Locked

    by ahuja.amit ·

    Hi all,

    i want to create partition on snapshot in my oracle database.

    but m not able to create it.

    so any one resolve the my problem.

    Thank’s

All Answers

  • Author
    Replies
    • #2926404

      Clarifications

      by ahuja.amit ·

      In reply to partition on snapshot

      Clarifications

    • #2808188

      Sample Partitioned Snapshot DDL

      by dkiz ·

      In reply to partition on snapshot

      create materialized view snap_sys_objects
      partition by list ( object_type )
      ( partition snpobj_table values (‘TABLE’)
      ,partition snpobj_INDEX VALUES (‘INDEX’)
      ,PARTITION snpobj_CODE VALUES (‘FUNCTION’, ‘PROCEDURE’, ‘PACKAGE’, ‘PACKAGE BODY’)
      ,PARTITION snpobj_REMAINDER VALUES (DEFAULT)
      )
      AS SELECT * FROM DBA_OBJECTS
      WHERE OWNER = ‘SYS’
      /

Viewing 1 reply thread