Not able to find the table name.

Not able to find the table name.

  

Hi all,

         I have a query like

  SELECT * FROM ( SELECT NULL o1, NULL o2 FROM "OSADMIN_OMC04"."OSSYS_USEREFFROLE_ T43" ENUser_Effective_Role WHERE (..........

Which is the last executed query as per oracle. now i am trying to find out this object (OSSYS_USEREFFROLE_ T43) but not able to search in ossys_entity table.


May i know what is this 'OSSYS_USEREFFROLE_ T43' ?

Is this a table name ? or  alias of table ENUser_Effective_Role 



Thanks

Rajendra Singh


Solution

Hi Rajendra,

there is a table called User_Effective_Role with physical name OSSYS_USER_EFFECTIVE_ROLE.

Yours (OSSYS_USEREFFROLE_T43) must be a reference to it in another espace...

Solution

Hi João Heleno

It means both table are same.



Thanks

Rajendra Singh