HOW TO MAKE MAX EXTENTS UNLIMITED AT SEGMENT LEVEL
704810Jun 21 2009 — edited Jun 22 2009HI GURUS
CAN ANY ONE TELL ME HOW TO MAKE MAX EXTENTS UNLIMITED AT SEGMENT LEVEL AND I AM USING THE BELOW QUERY TO FIND OUT SEGMENTS
SELECT distinct OWNER FROM DBA_SEGMENTS WHERE MAX_EXTENTS<>2147483645; AND I TRIED TO MAKE MAX EXENTS UNLIMITED WITH THE BELOW QUERY
select 'alter '||segment_type||' '||owner||'.'||segment_name||' storage (maxextents 2147483645);' from dba_segments where max_extents<>2147483645 and owner not in ('SYS','SYSTEM');
EVEN I AM GETTING FEW SEGMENT SHOWING LIKE THIS
OWNER
------------------------------
PORTAL30
PORTAL30_SSO
POS
PV
QA
SYS
SYSTEM
WMS
WSH
XDO
XDP
OWNER
------------------------------
XNP
78 rows selected.
CAN ANY GIVE ME THE QUERY TO MAKE IT AS UNLIMITED