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'