While moving objects from one tablespace to another tablespace ....!! [message #58364] |
Tue, 19 August 2003 09:46 |
raman
Messages: 66 Registered: February 2000
|
Member |
|
|
Hi
I have been trying to move the objects from one tablespace to another, as it got fragmented heavily.
Here, I am moving all the indexes to another tablespace, by calling INDX1.
But, I am unable to move some of them as it contains LOB objects etc.,
What'd be the solution?
-raman
|
|
|
|
Re: While moving objects from one tablespace to another tablespace ....!! [message #58366 is a reply to message #58365] |
Tue, 19 August 2003 10:21 |
raman
Messages: 66 Registered: February 2000
|
Member |
|
|
Hello Mahesh
Sorry, I have not undestood your answer...!
Here is what I am doing:
spool on
select 'alter index '||owner||'.'||index_name||' rebuild tablespace INDX1 ;' from dba_indexes where tablespace_name='INDX' order by owner, index_name;
spool off
Then I am trying execute the spooled file. Some of the indexes are giving problem like :
ORA-02327: cannot create index on expression with datatype LOB
ORA-02327: cannot create index on expression with datatype ADT
Any idea?
-raman
|
|
|
|
|
|
|
|
|