Oracle Expression Edition 10g tips and tricks

Published Wed 17 Mar, 05:44 by admin in oracle

Dealing with tables - Creating and Droping

Oracle Express is indeed a great way developing for Oracle database, it provides Apex (run on a small application server) that allows you to be DBA and a normal user without using any other tools for most tasks, even monitoring or executing jobs, scripts,etc. It can tuned (or de-tuned) to use less RAM (memory) on your workstation by changing SGA and PGA (PGA can be heavily reduced) parameters (still using a web tool). Of course this product comes with a limit of 1Gb max of RAM and few other limits which simply make sense.

Recycle Bin

Before you start creating tables and then droping them, you should realize that Oracle XE (express edition) has something called Recycle Bin.

Whenever you drop a table , a copy of that object is not really purged permanently , it is stored in a recycle bin, pretty much a simplified backup in case your app did something wrong.

Here comes the Tip

If you are completely sure that you droped the right table(s) , then Purge It with this command:

purge recyclebin;