OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora-25150

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-25150 [message #123956]

Wed, 15 June 2005 13:18

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai ,

we are getting ora-1691 when inserting lob.

first we tried to extend the maxextents but it gives ora-25150.so we created new tablespace with autoallocate and locally managed option and moved that table to that new tablespace.but now when inserting the lob, it gives ora-01502.what to do now..?client is waiting...urgent.plz help..

bala

Report message to a moderator

Re: ora-25150 [message #123960 is a reply to message #123956]

Wed, 15 June 2005 13:37

macdba
Messages: 27
Registered: May 2005
Location: US

Junior Member

When u move table from one tablesp to another, indexes for that table becomes invalid.
So rebuild all the indexes for that table.

alter index index_name rebuild online;

Report message to a moderator

Re: ora-25150 [message #123963 is a reply to message #123960]

Wed, 15 June 2005 13:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

as macdba said, you need to do some rebuild.
since lobs are involved, you need to move the lobsegments also.

something like
alter table lobtable move tablespace new_tablespace lob(lobcolum) store as lobsegment (tablespace new_tablespace).

And next time,
Please post something meaningful.
Your oracle versions / OS,
FUll error message etc.

[Updated on: Wed, 15 June 2005 13:43]

Report message to a moderator

Re: ora-25150 [message #123966 is a reply to message #123963]

Wed, 15 June 2005 13:57

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai,

oracle 9i server
linux - os

see , the table contains both lob fields and non-lob fields .i have rebuilt the index and moved the segments also.then what about the non-lob fields when i moved to new tablespace LOB2?

bala

Report message to a moderator

Re: ora-25150 [message #123968 is a reply to message #123966]

Wed, 15 June 2005 14:08

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

alter table lobtable -- a table with regular and lob data
move tablespace tools -- move the table data to tablespace tools
lob(lobdata) -- this lobdata is column in the table
store as lobsegment (tablespace tools) -- store it tablespace tools.

So you move the lob table.
and also the lob segments.

scott@9i > desc lobtable
Name                                     Null?    Type
---------------------------------------- -------- ----------------------------
ID                                                NUMBER
LOBDATA                                           CLOB


scott@9i > select tablespace_name,table_name from dba_tables where table_name='LOBTABLE' and owner='TEST';

TABLESPACE_NAME                TABLE_NAME
------------------------------ ------------------------------
USERS                          LOBTABLE

scott@9i > select tablespace_name,index_name from dba_indexes where table_name='LOBTABLE' and OWNER='TEST';

TABLESPACE_NAME 	       INDEX_NAME
------------------------------ ------------------------------
USERS                          SYS_IL0000006921C00002$$

-- 
-- Now Move the lob data to another tablespace
-- and check again.
-- 

scott@9i > alter table test.lobtable move tablespace tools lob(lobdata) store as lobsegment (tablespace tools);

Table altered.

scott@9i > select tablespace_name,table_name from dba_tables where table_name='LOBTABLE' and owner='TEST';

TABLESPACE_NAME                TABLE_NAME
------------------------------ ------------------------------
TOOLS                          LOBTABLE

scott@9i > select tablespace_name,index_name from dba_indexes where table_name='LOBTABLE' and OWNER='TEST';

TABLESPACE_NAME                INDEX_NAME
------------------------------ ------------------------------
TOOLS                          SYS_IL0000006921C00002$$

Report message to a moderator

Re: ora-25150 [message #123972 is a reply to message #123968]

Wed, 15 June 2005 15:13

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai mahesh,

the problem has been fixed.thanks a lot for ur timely help.

bala

Report message to a moderator

Previous Topic:	Loading data
Next Topic:	Badly named tablespace ( 'tblsp1.ora')

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:19:56 CDT 2024