Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » APEX 19.2 and DBLINK - Indexes (Oracle 11g - APEX 19.2)
APEX 19.2 and DBLINK - Indexes [message #679385] Thu, 27 February 2020 03:26
AdrianWard
Messages: 21
Registered: September 2019
Junior Member
Hi

I finally gave up trying to install 19.2 on my 11g Oracle database and created a brand new server to host APEX19.2, using DBLINKS to connect to the Oracle 11g database.

I moved all my APEX specific tables, PL/SQL views and triggers etc directly into APEX (originally created on 11g DB), however I still access some Oracle tables in queries (AR tables mainly).

I have a load of indexes between my APEX tables and the Oracle AR tables that are currently created on the Oracle DB. Would these be better created within APEX or would they work better left in Oracle?

Thanks in advance

Adrian
Previous Topic: Encrypt decrypt PL SQL Packages in oracle
Next Topic: In Reports , download and emails
Goto Forum:
  


Current Time: Wed Dec 04 13:13:06 CST 2024