1
votes

I have created a workspace named ITCMS online using Oracle CMS. There is a single schema inside named cmsonline. While creating the workspace, APEX didn't ask if I wanted to create a sys or system user.

Currently, my username to login into the workspace is my email ID.

Is it possible to access this online workspace using SQL developer?

1

1 Answers

5
votes

If you are talking about an APEX workspace created on http://apex.oracle.com, no, you cannot access the database Oracle hosts from your client machine. You can use the SQL worksheet functionality within the APEX developer environment. If you want to be able to connect to a database using SQL Developer, you'll want to install a local Oracle database and create a workspace there.

As an architectural aside, be aware that APEX users are not Oracle database users and APEX workspaces are not Oracle databases. You can create many different workspaces in a single Oracle database (apex.oracle.com is a single Oracle database hosting thousands of workspaces). And APEX users are not Oracle users so you can't connect to the Oracle database using an APEX user's credentials.