If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Actually, I was in a hurry. I meant the object does not exist in the database when I desc it in SQL Plus. Thanks a lot for all of your help and responses I am greatful for such a great repsonse. I am very new to Oracle DBA stuff. I would like to ask you guys for another favor. I have searched books on the same matter, such as oracle tuning and dynamic tables and views in oracle. Would you guys recommend a good book which has good reviews for someone like me who wants to delve into V$ views? Thank again.

V$ views mean nothing until you understand what is going on. Reading most books out there will lead you down the path of measuring by ratios and counts and when you think you know something we'll blow you out of the water. I suggest reading the Concepts manual twice before even thinking about the v$ views.

Thanks for your advice. I am actually reading a lot and trying to get the concepts straight on Oracle and the nuts and bolts of oracle. Before I go into the details of that I have another problem that I am facing.

Yesterday, my table got locked up. And I was trying to find:

1. what table was locked?
2. what locked it up?

when I restarted my server and rollback the database before the lock up actaully happened. When it restarted, it showed me the BEFORE Trigger that caused the lockup on my SHIPMENT TABLE.

This BEFORE trigger which updates another table in our database. Btw, we are using Oracle forms6i for the front-end.

The thing, that I want to know now is what application that the user was using that locked my table up. I know the sid and session but is it possible to find out what application that is doing this lock up on our table. In here, users have different application screens that they are using but we don't know what screen or the application that is causing the lockup when we are trying to UPDATE the SHIPMENT Table but no problem on INSERT though. I am not sure of you would be able to come up with the solution or if there is even a way to find what I am wanting. Anyways, I just thought there might be somoene out there who can shed some light. Thanks again to all of you.

I checked the script and I realized that it was creating the synonyms based on tables that does not exist in our database. I think if i need to create the views I need to make sure that all the tables that the views require exists on the database. I think to do something like this, is a little bit risky esp. messing around with databases. I simply want to learn more and test those things on my own machine.

But, I still want to find out the solution for the problem that our aplication my be causing to the table's trigger. Thanks.