Hi
I need to create a view on the table T003T however when I try and create the view in sqlplus it says the table does not exist. But in SE11 the table does exist and is described as a pool table.
as the sql user SAPSR3 I did this
SQL> create view VPC_T003T as select * from T003T with read only;
create view VPC_T003T as select * from T003T with read only
*
ERROR at line 1:
ORA-00942: table or view does not exist
So I tried this
SQL> desc sys.t003t
ERROR:
ORA-04043: object sys.t003t does not exist
SQL> desc system.t003t
ERROR:
ORA-04043: object system.t003t does not exist
SQL> desc sapsr3.t003t
ERROR:
ORA-04043: object sapsr3.t003t does not exist
SQL> select * from dba_objects where object_name='T003T';
no rows selected
How can I create a view in sqlplus on a pool table?
Any help appreciated
Thanks
Steve