Unanle to run update query

[Former Member]

Hi Experts,

I got the solution from SAP to run update query on table E071 by using SQLPLUS prompt.

But when I run this query I am getting message as below:

ERROR at line 1:

ORA-00942: table or view does not exist

I am also unable to execute simple query like

- select * from E071;

- desc E071;

For all above queries I am getting the same message as shown.

But I am able to open view the table in SE11.

I am also able to execute the following query in sqlplus -

- select owner, table_name from all_tab_cols where table_name like 'E071';

- select * from all_tables where table_name like 'E071';

Please provide me the solution / alternative to run this update query on table E071.

Thanks in Advance

Best RG//

Ramesh.

[volker_borowski2]

Hi,

if you use

sqlplus / as sysdba

you are SYS to the DB. You need to specify the schemauser.

desc sapr3.E071

desc sapsr3.E071

desc sapsid.E071

depending on how you schemauser is named.

check your sidadm environment:

env | grep -i schema

Hope this helps

Volker

[Former Member]

Hi Volker,

Thanks a lot.

For me I used sapsr3.E071 in my query and its working now.

Regards//

Ramesh