Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    New York
    Posts
    2

    Unanswered: Columns used in triggers

    Hi,
    Could someone help me with finding what coumns an index uses. All_indexes tells me the index name and the table name but not the columns. Thanks

    RSP.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    indexes
    ---------
    user_ind_columns
    all_ind_columns

    triggers
    ---------
    user_trigger_cols
    all_trigger_cols

    hth
    bill
    Last edited by billm; 11-09-02 at 14:36.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Here is the query:

    SELECT table_name, index_name, column_name
    FROM dba_ind_columns
    WHERE index_name = 'YOUR_INDEX_NAME' AND
    owner = 'YOUR_USER';


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •