ora -01652 error when the tablespace still have free blocks
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'