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

Posted on 2014-08-05
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 34

    Expert Comment

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

    Based on the Oracle documentation (, 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 73

    Accepted Solution

    yes it is ok to drop the table - as long as you don't have code that tries to populate it.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now