Skip to Content
0
Former Member
Oct 31, 2012 at 01:10 PM

How to create a view on pool table T003T in Oracle 11

411 Views

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