1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Tablespace with LOB

Discussion in 'System Administration & Application DBA' started by sidharthmellam, Jan 18, 2011.

  1. sidharthmellam

    sidharthmellam Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Dear Peers,

    Pl suggest, the best way to deal with, If the tablespace contain LOB.

    how to retrieve the space here


    Regards
     
  2. SBH

    SBH Forum Expert

    Messages:
    99
    Likes Received:
    6
    Trophy Points:
    160
    Location:
    Bangalore
    Please elaborate your ques bit more. Let us know what is the problem you are facing if your tablespace contains LOB and what space you want to retrieve.
     
  3. sidharthmellam

    sidharthmellam Active Member

    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    80
    Hi SBH,


    I mean to ask, whether to go for segment shrinking for retrieving
    space, of tablespace which contain the LOB

    Pl do suggest, am beginner in Oracle

    also do suggest any other forums ,

    if the above question is not appropriate for this forum

    but pl do reply to my query

    Thanks
     
  4. Jyoti

    Jyoti Active Member

    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    65
    Hi,

    Please elaborate the exact issue.