Database Administration (MOSC)

MOSC Banner

ora -01652 error when the tablespace still have free blocks

edited Apr 27, 2011 7:58PM in Database Administration (MOSC) 3 commentsAnswered
 I am running a query:

SELECT 'create materialized view '||a.owner||'.'||a.mview_name|| '
   pctfree 5
   pctused 50
   tablespace company100_d01
   storage (initial '||b.initial_extent||' next '||b.next_extent||' pctincrease 0)
   using index
   tablespace company100_i01
   storage (initial '||c.initial_extent||' next '||c.next_extent||' pctincrease 0)
   refresh complete with rowid
   as select * from '||a.owner||'.'||a.mview_name||'@prod.world;'
FROM dba_mviews a, dba_tables b, dba_indexes c
WHERE a.owner='USERA'
  AND a.mview_name like '%100'
  or a.mview_name like '%130'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center