Home » RDBMS Server » Server Administration » how to recreate lobindex? (product)
how to recreate lobindex? [message #508695] Tue, 24 May 2011 02:08 Go to next message
oyhuan
Messages: 1
Registered: May 2011
Junior Member
i missed a tablespace that includes more than 20,000 indexes for reason. there is nothing to do with it without recreate these indexes.i could find these index's ddl createment from "dbms_metadata.get_ddl" packages.
but the DDL createment like this:

CREATE UNIQUE INDEX "AMV"."SYS_IL0000241510C00002$$" ON "AMV"."DR$AMV_C_CHANNELS_DESC_CTX$R" (
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
PARALLEL (DEGREE 0 INSTANCES 0)

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
*
ERROR at line 2:
ORA-00936: missing expression

note: this tablespace is in ORACLE EBS R11 name "APPS_TS_TX_IDX"
how to recreate LOBINDEX?
please help me,thank you

Report message to a moderator

Re: how to recreate lobindex? [message #508699 is a reply to message #508695] Tue, 24 May 2011 02:21 Go to previous message
desertman909y
Messages: 9
Registered: May 2011
Location: dubai
Junior Member
How are you trying to rebuild the lob index?

There is no alter table rebuild... or alter index rebuild command
that will support this.

The only way to rebuild the lob index that is created because of a LBO
column is to drop and recreate the table

Report message to a moderator

Previous Topic: insufficent privliges to other user(exclude sys)
Next Topic: Installation of 11gR2 on Windows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 06:30:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.