ORA-00942: table or view does not exist

SVRMGR> @alter_table_prod.sql
ALTER TABLE MYTABLE_NAME
*
ORA-00942: table or view does not exist

ALTER TABLE MYTABLE_NAME
ADD (FIELD1 VARCHAR2(1),

FIELD2 DATE,
FIELD3 DATE,
FIELD4 DATE,

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? Received on Thu Dec 30 2004 - 02:46:25 CST