Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Dollar sign usually means "don't touch me". – Niko Kiiskinen Jun 12 '13 at 19:59
up vote 10 down vote accepted

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.

share|improve this answer
+1, I took too long double-checking a reference, so Justin beat me to it. – Aaron Mar 21 '12 at 2:15
Hiya, i deleted those tables before you gave an answer lol, thank god nothing stop working, however i dont like seeing tables other than the ones i want to insert, is there anyway to not display those tables. – D.G Mar 21 '12 at 15:17
@JoseDavidGarciaLlanos - Where are you seeing the table names displayed? Assuming that you are creating a new schema for your objects rather than trying to reuse a schema that Oracle delivers (and there are a number of them with a number of different tables none of which should be dropped or deleted from), you can just query the USER_TABLES view rather than DBA_TABLES or ALL_TABLES to see just the tables in your current schema. – Justin Cave Mar 21 '12 at 15:27
Hiya, i have added the images in the question :) – D.G Mar 21 '12 at 15:54

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.

share|improve this answer

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

share|improve this answer

those tables are for APEX Websheets. Unless you are making a websheet application they are of no use.

share|improve this answer
I'm not sure this adds anything to @awi64's answer, does it? – Jack Douglas Nov 3 '12 at 10:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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