Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora:00942

11g.DBAMay 9 2013 — edited May 10 2013
Hi all,

I am getting a problem.When I am trying to modify column,table or view doesnot exist error popping up but table exists in the database.

SQL> alter table md_board_confirm_auth_16
  2  modify(REMARK      Varchar2(1001 char)
  3  );
alter table md_board_confirm_auth_16
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> desc md_board_confirm_auth_16
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(12)
 REMARK                                             VARCHAR2(1000 CHAR)
 SIGNED_BY                                          VARCHAR2(500 CHAR)
 EXTRA                                              VARCHAR2(500 CHAR)
 HOSPITAL_ID                                        NUMBER(12)
 LAST_CHG_BY                                        VARCHAR2(100)
 LAST_CHG_DATE                                      DATE
 LAST_CHG_TIME                                      VARCHAR2(100 CHAR)
 MD_BOARD_ASSISTANT_ID                              NUMBER(12)
 STATUS                                             VARCHAR2(20 CHAR)
Thanx all
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2013
Added on May 9 2013
2 comments
205 views