How to delete an Oracle table?

Question

Rather than being dropped and recreated (which is what util a/17/1 does) the Aleph Oracle table shall actually be deleted.

Answer

1. Make certain that the table is really not needed. Examples of possibly unneeded tables are

z34 (IP STATISTICS) table: see also article Are util_a13_b job and z34 table necessary

z35 (Events) table in the bib library: see also article Is z35 written to by GUI searches

2. > s+ xxx01

3. SQL> drop table z35;

Additional Information

Important note: the 'drop' command does not require a 'commit' to be executed. The table will be deleted immediately!

Please make sure to have a recent backup in order to avoid unwanted data losses.
 

• Article last edited: 27-Oct-2016