default workspace after migration to 11g

Question

I installed 11g on my local machine and imported my data using dmp file. Now my application works fine and also I can connect to database using sql developer without any problems.

But when I try to login with apex, I don't know what to enter in workspace field. I used INTERNAL workspace with admin as username. But i couldn't find my tables and schemas.

I went to workspace manager and found that only INTERNAL workspace is defined there with a single user(admin).

How can I view and manage my existing tables using apex? (As i said above, i can do it using sql developer. But I want to do it using apex)

Answer 1

Apex is an application development environment, that happens to have some tools for managing schema objects, but for this purpose is not as powerful or easy-to-use as SQL Developer.

If you really want you could login as the administrator and create a workspace, but I'd rather use SQL Developer unless I was actually going to use Apex for its main purpose, which is building applications.