How to Understand Missing Tables in Table Explorer
Issue
A table is not visible in the Table Explorer, despite the table being present in the database.
This article demonstrates two scenarios.
- Table Explorer does not list
a1_tpcc
because it is owned by thetpcc
schema and thehvrhub4
schema does not have SELECT privilege on it - Table Explorer does not list
a1_temp
because it is a global temporary table
In the following examples:
- Oracle is the source database
- The schema
hvrhub4
is the hub schema a1_temp
is a global temporary table present in thehvrhub4
schemaa1_tpcc
table is owned by thetpcc
schema
Scenario 1
HVR 5 user hvrhub4
does not have the privilege to select the table a1_tpcc
.
Steps: Grant hvrhub4
privilege to select the table a1_tpcc
.
Scenario 2:
The table a1_temp
is a global temporary table. If the table is visible in the database schema but it is not visible while adding to the replication, it is possible that this table is a temporary table.
Run the below query to get the DDL of the table a1_temp
. The DDL of the table tells if it is a temporary table.
SQL> spool ddl_list.sql;
SQL> SET HEADING OFF;
SQL> SET ECHO OFF;
SQL> SET PAGES 999;
SQL> SET LONG 90000;
SQL> SPOOL DDL_LIST.SQL ;
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','A1_TEMP','HVRHUB4') FROM DUAL;
Result of the query:
CREATE GLOBAL TEMPORARY TABLE "HVRHUB4"."A1_TEMP"
( "C1" NUMBER(*,0),
"C2" VARCHAR2(25 BYTE)
) ON COMMIT DELETE ROWS ;
Steps: There is no resolution to this scenario. HVR 5 does not support global temporary tables because they are not static.