Moving drsys01.dbf to another location with more space.
======
ora> shutdown immediate
Copy drsys01.dbf to another location
cp ...
Startup mount
alter database rename file '/ora8/m01/app/oracle/oradata/ora8/drsys01.dbf' to
'/new/location/drsys01.dbf';
>statement processed
create index cr_rev_content_index ...
and right after it started ...
alter table MYUSER.DR$CR_REV_CONTENT_INDEX$I
storage (maxextents 2000);
======================
after about 2h got an error:
----------------------
SQL> create index cr_rev_content_index on cr_revisions (content)
2 indextype is ctxsys.context
3 parameters ('FILTER content_filter_pref');
create index cr_rev_content_index on cr_revisions (content)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-50857: oracle error in drixtab.create_index_indexes
ORA-01630: max # extents (249) reached in temp segment in tablespace MYUSER
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 78
ORA-06512: at line 1
SQL>
checked index cr_rev_content_index and it shows as valid,
will investigate if this caused any damage.
Now, what does it mean? and why?
