Question

Locked

partition on snapshot

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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

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'
/

Back to Hardware Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums