Data Loss Prevention

 View Only

  • 1.  Tablespace is 99%

    Posted Dec 06, 2016 11:04 PM

    Dear guyz

    Please help me regarding the table space issue, as I don't have any idea or any guidance that how to free up some space in tablespace.

     

    When i go to System --> Database --> tablespace summary. 

    I see the following condition of my tablespace. 

    I deleted all archived incidents but no joy. Please help me. its urgent.

     

    tablespace-overview.jpg 

     

     

    Thanks

    Regards

     

    Zuhaib Siddiqui



  • 2.  RE: Tablespace is 99%
    Best Answer

    Trusted Advisor
    Posted Dec 08, 2016 07:19 AM

    hello,

     

    Your issue is related to how oracle managed LOB spaces. You may have a look at this article which explains why and how to solve it

    http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_85.shtml

     

    main DLP tables/columns which used LOB_TABLESPACE for incident data storage are :

    MessageLob / column networkOriginalMessage

    MessageComponentLob / column uncrackedComponent and column crackedComponent

    ConditionViolationLob / column crackedComponentMarkers

     

     Regards