I’m a Toad Data Point (TDP) newbie and I’m using TDP version 3.5 Pro Edition. My apologies if this question has already been asked and answered somewhere else–I did some searching but didn’t find my exact issue.
I’d like to be able to create and store local analysis tables using the cross-connection query capability in TDP. However, I’m running into the following error:
ERROR on line 1, col 14, offset 13: Heterogeneous Query extension found but appropriate QP5 language extension not set
Here is my simple query example:
Local Storage Connection.LOCALSCHEMA.L_EXAMPLE_TABLE AS
SELECT * FROM
While this is just a really simple example query to demonstrate my problem, I’d really like to be able to write cross-connection queries that use multiple local and external tables to create and store new local analysis tables–kind of like using DB links.
Another post suggests that I might not be able to copy a table locally like this using a cross-connection query and that I should possibly use the Data Import Wizard instead–is this really my only option?
Thanks for your help!