Unable to create the status and tracking tables for cache datasource

[Jyothsna Nayak]

I have createda new Oracle Datasource. It has connected successfully and introspection is complete. I am trying to setup cache (single or multiple table) for this datasource. However when I click Browse to create the management tables (tracking and status), the "create table" option does not come up - screenshot is attached.

How can I createthe management tables so that this datasource can be used for caching purposes Thanks, JSN

[Motsu Aboshi]

Does it show up if you select the schema/catalog, instead of the top-level data source 

 

Which version of Oracle is it

[Jyothsna Nayak]

I was able to make it work. The DDL was generated after I addedan existingschema during introspection. I had previously not added any schemas from the database.

I then had to select the schema during cache management tables setup. TDV generated theDDL and tables were created under the selected schema.

I am using Oracle 12c (Thin Driver).

Thanks, JSN