My Oracle Support Banner

'Edit Create Table Or View Node' Window Showing check box KEY and INDEX Grayed Out (Doc ID 2326580.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle SQL Developer - Version 4.2.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


Data Miner "Edit Create Table or View Node" window dialog box shows check boxes for KEY and INDEX grayed out.

This issue can be simply confirmed by the following steps:

1. Data Miner
-> New Project (Create Projext)
-> New Workflow

2. [Workflow Editor]
Data -> "SQL Query" -> SQL Query Node Editor -> Input any query

3. [Workflow Editor]
Data -> "Create Table or View"

4. Connect from "SQL Query" to "OUTPUT"

5. Double Click the "OUTPUT"

6. KEY and INDEX check boxes cannot be selected. 



This issue is not reproducible in SQL Developer 4.1. 



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.