Where is my schema?July 17, 2015 at 5:17 pm | Posted in Oracle Developement | Leave a comment
Tags: apex, application express, oracle, pl/sql
I just came accross a little nuisance: During attempt to load some spreadsheet data into a new table using the APEX Data Load wizard in the SQL Workshop, I saw that the Schema select list was empty:
The issue was that the parsing schema was granted CREATE ANY TABLE. However for this list to be populated, the parsing schema needs the CREATE TABLE privilege.