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