VERIFIED SOLUTION i
X

"_BASE" is used as a table naming convention but the resulting table name does not show up in the Open Table dialog

UPDATED: March 31, 2017


"_BASE" is used as a table naming convention but the resulting table name does not show up in the Open Table dialog.

Customers connecting MiPro to an Oracle database that use a table naming convention of TableName_BASE can create tables in Oracle and tables appear and are listed in the database.
However, when opening in MiPro via an ODBC/OCI connection to Oracle, the tables with xxx_BASE as a naming convention do not appear in the Open Table file list.

"_BASE" is one of several extensions of Oracle helper tables used for versioning. MiPro filters out such tables from the list.

Here is the list of all such extensions:
**********************************************
TCHAR * szVersionEnabledHelperTableSuffixes[] = {
// Views, unless noted
_T("_AUX"), // table

_T("_BASE"),
_T("_BPKC"),

_T("_CONF"),
_T("_CONS"),

_T("_DIFF"),
_T("_DIF1"),
_T("_DIF2"),

_T("_LOCK"),

/* "_HIST", user may want to collect info from this view*/

_T("_LT"), //table
_T("_LTB"),

_T("_MW"),

_T("_PKC"),
_T("_PKD"),
_T("_PKDB"),
_T("_PKDC"),

_T("_RI$B"),
_T("_RI$T"),

_T("_VTB"),
0
};
*********************

The list of extensions should be avoided for use as table naming conventions within Oracle.

Environment Details

Product affected: MapInfo Professional™

Downloads

  • No Downloads