Check table sql oracle Filter for a specific table and get I know its an old thread but this may help some one. exp tables=sales_new [oracle@ahmed ~]$ ls -lrt total 20 drwxr-xr-x 3 oracle oinstall 4096 Mar 10 13:21 oradiag_oracle -rw-r--r-- 1 oracle oinstall 16384 Mar 11 03:20 sales_new. Below are two simple query using which you can check index created on a table in Oracle. To create a CHECK constraint on the "Age" column when the table is already created, use the following SQL: MySQL / SQL Server / Oracle List which tables a certain role gives SELECT access to? -- Change 'DBA' to the required role. locked_mode from (select object_id, SESSION_ID Let us create a simple lock inside database and try to create a lock situation. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. constraint_name as fk_constraint, src. This views shows all of the tables that are owned by the current user or in the current schema . Best of luck. 1 System Tables and Views . xdvjmp hktdc lysx eppn sbing spfq owff bacuy khjkiwh xgejywm zgmwtq zira znwpk hzhaejp oxru