BLOB's and other large objects are stored in the database. Normally in a
tablespaces specifically for LOB data. You must be thinking of BFILE
data which is stored externally with a logical location stored in the
database.
IJCA,
Gil Bruce
-----Original Message-----
From: Vaishali Kamdar
[mailto:oracledba-ezmlmshield-x40252248.[Email address protected]
Sent: Tuesday, October 09, 2007 6:20 AM
To: LazyDBA Discussion
Subject: RE: Online Reorg and BLOB column
I don't thinks so because as per my knowledge blob data is stored in
external tables and that at file system level.
Please correct me if I am wrong..
Regds,
Vaishali.
-----Original Message-----
From: Achmad Dimyati
[mailto:oracledba-ezmlmshield-x7840610.[Email address protected]
Sent: Tuesday, October 09, 2007 3:47 PM
To: LazyDBA Discussion
Subject: Online Reorg and BLOB column
Hi Gurus,
Need your confirmation.
I conduct online reorg for table with BLOB column.
Do BLOB column will be reorg too?
Oracle 9.2.0.2
Thanks a lot.
Best Regards,
Achmad Dimyati
Basis Consultant
Axon Solutions Sdn Bhd
L5E-1B, Enterprise 4
Technology Park Malaysia
Bukit Jalil, 57000 Kuala Lumpur
Achmad.[Email address protected]
Office tel: +(603) 8994 1089
Idd tel : +(603)8991 8116
Office fax: +(603) 8994 1098
www.axonglobal.com
The content of this email is confidential and for the
addressee only. If you are not the addressee of this
email (or responsible for the delivery of this message
to such person) you may not copy, forward, disclose
or otherwise use it or any part of it in any form
whatsoever. If you have received this email in error
please email the sender by replying to this message
and delete this message thereafter.
Opinions, conclusions and other information in this
message that do not relate to the official business
of our Company shall be understood as neither
given nor endorsed by it.
Axon Solutions Limited
Registered Office: Axon Centre, Church Road, Egham, Surrey, TW20 9QB, UK
Registered in England & Wales under Company No. 2976395
Axon Solutions Limited is a limited company.
Axon Group plc
Registered Office: Axon Centre, Church Road, Egham, Surrey, TW20 9QB, UK
Registered in England & Wales under Company No. 3419641
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are
solely for the use of the individual or entity to which it is addressed.
Any use, distribution, copying or disclosure by any other person is
strictly prohibited. If you receive this transmission in error, please
notify the sender by reply email and then destroy the message. Opinions,
conclusions and other information in this message that do not relate to
official business of the company shall be understood to be neither given
nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information
contained in this email, when addressed to Clients is subject to the
terms and conditions in governing client contract.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page