yls177 wrote:
> 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?
Although I generally prefer specifying the owner of the table, you could
create a private synonym for the specified table as an alternative
before submitting your alter table.
Received on Thu Dec 30 2004 - 20:26:21 CST
