Oracle

Oracle#

The Oracle provider is bundled with Querona and no installation or configuration is required. Querona uses Oracle Data Provider for .NET (ODP.NET) Core, version 23.26.2 or later.

Excluded Oracle schemas#

The following schemas are excluded by Querona’s schema importer. This means that during metadata import from Oracle, Querona will not load and present objects that reside in these schemas:

  • ANONYMOUS

  • APPQOSSYS

  • AUDSYS

  • BI

  • CTXSYS

  • DBSNMP

  • DIP

  • DVSYS

  • EXFSYS

  • FLOWS_FILES

  • GSMADMIN_INTERNAL

  • HR

  • IX

  • MDDATA

  • MDSYS

  • MGMT_VIEW

  • OE

  • OJVMSYS

  • OLAPSYS

  • ORACLE_OCM

  • ORDDATA

  • ORDPLUGINS

  • ORDSYS

  • OUTLN

  • OWBSYS

  • OWBSYS_AUDIT

  • PM

  • SH

  • SI_INFORMTN_SCHEMA

  • SPATIAL_CSW_ADMIN_USR

  • SPATIAL_WFS_ADMIN_USR

  • SYSMAN

  • SYSTEM

  • SYS (except Dual table)

  • WMSYS

  • XDB

  • XS$NULL

  • LBACSYS

  • WK_TEST

  • WKSYS

  • WKPROXY

See also#