DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: LOB object drop error

  1. 02-09-2011, 11:24 PM #1
    getnami
    getnami is offline Junior Member
    Join Date
    Oct 2009
    Posts
    30

    LOB object drop error

    Hi,

    In the process of refreshing a schema, I have already dropped the columns from LOB table.
    Then I tried dropping the rest of the objects, but few objects of type LOB are not getting dropped and I am receiving the below error:

    drop LOB ABC.SYS_LOB0000435014C00002$$
    *
    ERROR at line 1:
    ORA-00950: invalid DROP option

    (Here LOB-> object type and ABC- owner)

    Can someone please help in resolving the same and what could be its affect on the refresh.


    Thanks in advance
    Regards,
    Aakriti
    Reply With Quote Reply With Quote
  2. 02-10-2011, 11:36 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    There is not such a command as drop lob.

    LOBs are datatypes, datatypes for columns that are stored into tables so you can delete rows and truncate tables.

    If what you want is to get rid of physical files you have to purge.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 02-14-2011, 06:43 AM #3
    getnami
    getnami is offline Junior Member
    Join Date
    Oct 2009
    Posts
    30
    Hi,

    I have dropped the LOB objects by dropping the column of the LOB_table.
    Then tried dropping the objects of the schema, wherein encountered this error.
    Also, purged the recyclebin, yet receiving the same error.

    I hope its more understandable now. Any help please.

    Thanks in advance

    Regards,
    Reply With Quote Reply With Quote
  4. 02-17-2011, 08:22 AM #4
    mayura.ch
    mayura.ch is offline Junior Member
    Join Date
    Feb 2010
    Posts
    36
    can you do "purge dba_recyclebin;" and check.

    Regards...Mayura
    Reply With Quote Reply With Quote
  5. 02-17-2011, 09:48 AM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by getnami View Post
    Hi,

    I have dropped the LOB objects by dropping the column of the LOB_table.
    Then tried dropping the objects of the schema, wherein encountered this error.
    Also, purged the recyclebin, yet receiving the same error.

    I hope its more understandable now. Any help please.

    Thanks in advance

    Regards,
    receiving what error, what exactly are you trying to do?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width