Schema LOV Is NULL When Trying to Create A New Table Via SQL Workshop --> Data Load
(Doc ID 1340269.1)
Last updated on APRIL 24, 2024
Applies to:
Oracle Application Express (APEX) - Version 3.1.2.00.02 to 4.0.2.00.07Oracle Database Cloud Exadata Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When trying to create a new table in SQL Workshop --> Load Data (be it via Text or Spreadsheet Data), then the schema LOV is NULL - see image below
As a schema cannot be entered via the LOV or the Keyboard, the Developer therefore has to create the new database table. The schema which the workspace is based on has the CREATE TABLE privilege and a table can be created via SQL Workshop --> SQL Commands.
Cause
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
Symptoms |
Cause |
Solution |
References |