Re: LOB schema object?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 May 2002 09:19:19 +0100
Message-ID: <1021969688.10216.0.nnrp-08.9e984b29@news.demon.co.uk>

You can't just delete this object, it represents a LOB column in another object.

Going on the object_name of

SYS_LOB0000024704C00002$$ Look for object 24704, column 2 to find out what it really is.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Marcin Buchwald wrote in message <3CE9FFD6.955F4725_at_agora.pl>...


>On my production database I found an object that is mystery to me.

>It's found in all_objects view

>

>select * from all_objects where object_type='LOB';

>

>OWNER                          OBJECT_NAME

>SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID

>OBJECT_TYPE        CREATED          LAST_DDL_TIME    TIMESTAMP

>STATUS

>------------------------------ ------------------------------

>------------------------------ ---------- --------------

>------------------ ---------------- ---------------- -------------------

>-------

>SPACE_RESERVATION

>SYS_LOB0000024704C00002$$

>24705          24705 LOB                28/03/2001 13:25 28/03/2001

>13:25 2001-03-28:13:25:10 VALID

>

>My intuition says that this object is concerned with Java VM.

>

>The Questions:

>

>1. What is this

>2. What is this for

>3. ... can I detele this

>4. ... how to delete this (don't found DELETE LOB statement...)

>

>Regards,

>

>        Marcin

>

>

Received on Tue May 21 2002 - 03:19:19 CDT