Home » SQL & PL/SQL » SQL & PL/SQL » What is the scenario for not possible to create index for the table? (oracle pl/sql)
What is the scenario for not possible to create index for the table? [message #578379] Wed, 27 February 2013 06:22 Go to next message
prabum82
Messages: 2
Registered: February 2013
Location: chennai
Junior Member
What is the scenario for not possible to create index for the table?
-prabu
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 Go to previous messageGo to next message
Roachcoach
Messages: 1219
Registered: May 2010
Location: UK
Senior Member
Several.

Can you be a little clearer in the question?
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 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2049
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 Go to previous messageGo to next message
pablolee
Messages: 2655
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.
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 Go to previous messageGo to next message
pablolee
Messages: 2655
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
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 Go to previous messageGo to next message
bharathi89
Messages: 39
Registered: May 2012
Location: chennai
Member
@pablolee We Can Create Imaginary Index For Imaginary Table
Razz
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 Go to previous messageGo to next message
Bill B
Messages: 1116
Registered: December 2004
Senior Member
paste in the command that you are typing to create the index and what oracles error code is.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 59414
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
Previous Topic: ORA-06531: Reference to uninitialized collection
Next Topic: splitting data and store the data into columns
Goto Forum:
  


Current Time: Tue Oct 21 22:53:28 CDT 2014

Total time taken to generate the page: 0.14911 seconds