Re: updates accoross a database link
Date: 1995/10/16
Message-ID: <45u0o0$41h_at_crissy.ge.com>#1/1
The user_ind_columns view is the one "belonging" to the username set up to connect the the database when you link. (Links are usually set up by DBA.) The query would reflect your changes only if the creating username was also the linking username (unlikely).
Try using the view all_ind_columns (& all_indexes, all_tables, etc.). This view will reflect all the indexes on tables that the linking username has permission to SELECT from. Therefore, the linking username must have SELECT privileges on the table(s).
You can check the linking username by looking at table ALL_DB_LINKS on the database you are *connecting to*.
Feel free to contact me with more questions
Donna Kray ph. 219.439.4103
email: kray.donna_at_mlink,motors.ge.com
sahmad_at_mfa.com (Saad Ahmad) wrote:
>Hi
>
>I am using Oracle 7.0.1.6
>
>on database 1 call sqlplus
>on database 2 call sqlplus
>on database 1 craeate an index
>on database 2 when i see the user_ind_columns_at_databse2
> it does not show the new index ....?
>
>--
>**************************************************************
>* Saad Ahmad *
>* McHugh Freeman & Associates, Inc. *
>* Ph: (414) 798-8606 Ext. 457 *
>* Fax: (414) 798-8619 *
>* E-Mail: sahmad_at_mfa.com *
>**************************************************************
>
Received on Mon Oct 16 1995 - 00:00:00 CET