partition on snapshot
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
Hardware
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
by ahuja.amit Accepted solution
by dkiz Accepted solution
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.
Sort by Trending