Creating An APEX applicationPosted: October 4, 2011
You need a container to house the application, in Oracle this is called a schema or user to us none Oracle DBA’s, confusing yes, but I am sure that an Oracle boffin would be able to explain it. All we need to know is that we need to create one.
You can either create one with the following script or let the create workspace wizzard help you
CREATE USER manufacturing IDENTIFIED BY “A Password”
DEFAULT TABLESPACE “USERS”
TEMPORARY TABLESPACE “TEMP”
QUOTA UNLIMITED ON “USERS”;
This guide will not take you through how to create a workspace or how to create an application as there are loads of books out there including some free Oracle guides, this and associated posts will hopefully get you around issues and tips to solve bits and pieces.