Re: ORA-00942: table or view does not exist

> >i found out that i have 2 owners to MYTABLE_NAME. And i need to
> >specify the owner as in MYOWNER.MYTABLE_NAME in my "alter statement"
> >before it can work?
> >
> >Also, can i do this during operation hours which meant that others are
> >accessing this table?
>
> To the first question: yes
> To the second question: if the table is in use by someone else, you
> will hit ora-0054 resource busy and acquire with nowait specified.
> You can retry later or perform the operation in your maintenance
> window. Directly altering tables in a production schema is of course a
> bad idea, and many sites uusually do this in a more controlled
> fashion.

And you should... I recall filling a servers rollback segments quickly when I once did a small Stored Procedure change on a running system...

Apparently, Oracle keeps something in the cache and uses that, but back tracks the rest as well :-)

Got an angry customer on the phone about 15 minutes later... :-)

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com