Not view triggers in table user_triggers

[mariocq]

Hello:

I am facing an strange problem, I can create triggers or table inside my DB with any user but whent I try to view these objects in tables like user_tables or user_triggers I can´t


XXX@/opt>sqlplus XXXX/XXX

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Aug 31 11:10:29 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> CREATE INDEX INSTANCE_ID_INX ON XXX_PROCESS_LOG(INSTANCE_ID, LOG_TIMESTAMP) TABLESPACE XXX_LOGS_IDX ;

Index created.

SQL> select * from user_triggers;

no rows selected

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
XXX@/opt>

 

[Dagon]

Why are you looking in USER_TRIGGERS after creating an index ?

 

[Beilstwh]

You want to look into user_indexes

Bill
Oracle DBA/Developer
New York State, USA