Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomeOracleOracle Error ORA-46267: Insufficient space in ‘string’ tablespace, cannot complete operation

    Oracle Error ORA-46267: Insufficient space in ‘string’ tablespace, cannot complete operation

    admin November 16, 2022 No Comments

    Oracle Error Message

    ORA-46267: Insufficient space in ‘string’ tablespace, cannot complete operation

    Reason for the Error

    Could not complete the operation because the DBMS_AUDIT_MGMT API involved movement of one or more audit tables and there was not enough space in the destination tablespace.

    Solution

    Turn on tracing using DBMS_AUDIT_MGMT.SET_DEBUG_LEVEL to find the amount of space required. Then, allocate that space in the destination tablespace, even if destination tablespace datafile has AUTOEXTEND option turned on. And then, retry the operation.

    Tag:

    Share:

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    You May Also Like

    Oracle Error CLSGN-32767: Internal error.

    Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
    Read more

    Oracle Error CLSGN-00211: OCR batch operation failed. string

    Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
    Read more

    Oracle Error CLSGN-00210: failed to get value for OCR key “string”. string

    Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...
    Read more