OraFAQ Forum: SQL & PL/SQL » What is the scenario for not possible to create index for the table?

Home » SQL & PL/SQL » SQL & PL/SQL » What is the scenario for not possible to create index for the table? (oracle pl/sql)

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

What is the scenario for not possible to create index for the table? [message #578379]

Wed, 27 February 2013 06:22

prabum82
Messages: 2
Registered: February 2013
Location: chennai

Junior Member

What is the scenario for not possible to create index for the table?
-prabu

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578381 is a reply to message #578379]

Wed, 27 February 2013 06:30

Roachcoach
Messages: 1032
Registered: May 2010
Location: UK

Senior Member

Several.

Can you be a little clearer in the question?

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578387 is a reply to message #578379]

Wed, 27 February 2013 07:11

Solomon Yakobson
Messages: 1398
Registered: January 2010

Senior Member

prabum82 wrote on Wed, 27 February 2013 07:22

What is the scenario for not possible to create index for the table?

Table is external table, for example. Or all table columns are LOBs or UDTs (object, nested table, varray). Probably more cases.

SY.

[Updated on: Wed, 27 February 2013 07:13]

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578416 is a reply to message #578379]

Wed, 27 February 2013 16:19

pablolee
Messages: 2078
Registered: May 2007
Location: Scotland

Senior Member

The table doesn't belong to you and you don't have the appropriate privileges to create an index.

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578417 is a reply to message #578379]

Wed, 27 February 2013 16:21

pablolee
Messages: 2078
Registered: May 2007
Location: Scotland

Senior Member

Another possibility, the person trying to create the index is incapable of understanding the syntax required to create an index. Or maybe it's an imaginary table Wink

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578424 is a reply to message #578417]

Wed, 27 February 2013 21:57

cvbharathi89
Messages: 35
Registered: May 2012
Location: chennai

Member

@pablolee We Can Create Imaginary Index For Imaginary Table
Razz

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578468 is a reply to message #578424]

Thu, 28 February 2013 09:50

Bill B
Messages: 986
Registered: December 2004

Senior Member

paste in the command that you are typing to create the index and what oracles error code is.

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578469 is a reply to message #578468]

Thu, 28 February 2013 09:53

Michel Cadot
Messages: 54171
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Who say OP did any command, he just asks a general question.
Please CAREFULLY read the posts.

Regards
Michel

[Updated on: Fri, 01 March 2013 07:17]

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578579 is a reply to message #578469]

Fri, 01 March 2013 06:01

prabum82
Messages: 2
Registered: February 2013
Location: chennai

Junior Member

Friends Thks for your ans...

1.Indexed columns size is greater then index.
2.Index size is greater than indexed_column.

which one is give performance issue?
-prabu

Report message to a moderator

Re: What is the scenario for not possible to create index for the table? [message #578581 is a reply to message #578579]

Fri, 01 March 2013 07:19

Michel Cadot
Messages: 54171
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The points are meaningless.
One is obvious, the other one is impossible, as far as we can understand them.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-06531: Reference to uninitialized collection
Next Topic:	splitting data and store the data into columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 01:12:03 CDT 2013

Total time taken to generate the page: 0.08865 seconds