Schema LOV Is NULL When Trying to Create A New Table Via SQL Workshop --> Data Load
Last updated on OCTOBER 27, 2016
Applies to:Oracle Application Express (formerly HTML DB) - Version 3.1.2.00.02 to 4.0.2.00.07
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms