Last post Aug 03, 2011 03:37 PM by Lannie
Aug 03, 2011 09:32 AM|cenk1536|LINK
I am using SQL Server 2008 R2 with a linked server to Oracle 10g. I can query a table from SQL Server which is in Oracle as follows:
Select * from [Database]..[Schema].[Table]
I wonder if I can somehow update an Index which is in Oracle from SQL Server.
Here is the Index:
DROP INDEX Schema.APP_PARMS_PK;
CREATE UNIQUE INDEX Schema.APP_PARMS_PK ON Schema.APP_PARMS
Aug 03, 2011 03:37 PM|Lannie|LINK
You would have to use Oracle Client logged in as the table owner to create an index,
the Oracle DBA would have to grant create any index to another Oracle schema owner (user), which most would not do for security reasons.
You could execute the DDL request (create index) via an Oracle Stored Procedure from .NET, again connected as a user with the proper create table/index object privileges.