i created a database schema in 11g express edition, however there are some APEX tables and some dummy data...

Is it safe to delete them? also i would like to know what does apex means and why they have a dollar sign, thanks...

APEX$_ACL                      TABLE
APEX$_WS_FILES                 TABLE
APEX$_WS_HISTORY               TABLE
APEX$_WS_LINKS                 TABLE
APEX$_WS_NOTES                 TABLE
APEX$_WS_ROWS                  TABLE
APEX$_WS_TAGS                  TABLE

apex cmd

apex web

I used SYS to create a new user, the new user was created along with a workspace and a database schema, please see the images above.

  • Dollar sign usually means "don't touch me". – Niko Kiiskinen Jun 12 '13 at 19:59

I wouldn't suggest removing those tables, no. The Oracle XE browser-based interface is written in APEX (Application Express, a framework for developing web-based apps in the Oracle database). If you break APEX, that interface will likely stop working.


APEX is an acronym for Oracle Application Express. Those tables are there to support some of the tools within APEX (like Websheets), so you should leave those alone.


Talking about the APEX$_ tables: Given that you are not using any Websheets applications, it's safe to drop them. This won't bother any of your regular APEX database applications.

What if you change your mind later on? Creating your first Websheet application, the wizard will detect all missing tables (even corrupt tables if you happended to alter them). A dialog comes up telling you "The database objects required to create Websheet applications are either invalid or do not exist". Click on "Manage Websheets Database Objects" and easily recover them in another wizard within just a few seconds. And you're done.

Test this behaviour in a free evaluation workspace on apex.oracle.com.

protected by Community May 27 '16 at 12:21

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.