Table created via Modeler perspective(SQL Console) or Development perspective(Repository)?

[naga_92]

Hello All,

I need to enhance few tables, procedures which are created by someone.

I need to enhance table or procedure with few changes but i am not sure how the table was created?
Whether via SQL Console or from Repository using development perspective ? i checked in the repository but table definition was not available but table was created with path name.

Is there any way to identify the same Please let me know.

Thanks and Regards,

Nagendra

[Cocquerel · Accepted solution]

Yes, you can check who is the owner of the table in view "SYS"."OWNERSHIP". If it is "_SYS_REPO", it is a repository object.