Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System.Data.OracleClient requires Oracle client software version 8.1.7 or g

910632Jan 13 2012 — edited Jan 17 2012
[C:\Documents and Settings\901376\Desktop\Oracle Error.JPG]

Hi All,

I have asp.net application which connects to oracle, i dont have code for it. i am getting the following error while trying to open a connection i believe. thought its permission issue and gave permission to folder C:\Program Files\oracle and added the Authenticated Users Group and gave permissions too.. tried giving full control.. nothing is working..

can anyone throw some light on this.

I have Oracle Client Administrator 10.0.3.0 installed.. uninstalled and reinstalled again. for a while it worked after repairing but after some time it is throwing the same error.

Comments

Tubby
Drop index un1 ;
create index un1 on xx_test (a1,a2,a3) ;
586651
I dont want to drop the index is it possible to alter?
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
Karthick2003
[ALTER INDEX|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1008.htm#SQLRF00805] is beautifully documented.

Thanks,
Karthick.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2012
Added on Jan 13 2012
2 comments
411 views