Question Locked

partition on snapshot

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by dkiz

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

This discussion is closed to new replies.