Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


dbms_errlog.create_error_log -- how do I drop the error log?

Posted on 2014-08-05
Medium Priority
Last Modified: 2014-08-05

Is it ok to just drop the error log table when not in use? I can't find information on the best way to drop the error log.

Is there work involved to keep the tables in sync when new columns are added to the main table?


Question by:gswitz
LVL 35

Expert Comment

ID: 40241145
I have never used this procedure, so I am learning something new here.

Based on the Oracle documentation (http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_errlog.htm#ARPLS680), it seems that the procedure just creates a table for you.  The best way to drop it would be DROP TABLE ...

To get a new version of the error log table if the base table changes, just drop and recreate the log table.
LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 40241188
yes it is ok to drop the table - as long as you don't have code that tries to populate it.

Author Closing Comment

ID: 40241319

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month13 days, 23 hours left to enroll

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question