I've read a LOT of the documentation, etc, regarding how LOB storage works (including Axton's very fine wiki on this topic) and I'm pretty familiar with it in theory.
We are doing a data migration at the moment which is using an enormous amount of space. We are in the process of migratiing 330,000 records as a test. This has used (so far) 33 GB of table space. We only have 47 GB in this test system. Considering the actual ARX exports were < 1 GB something is clearly not right here. Initial consultation with a DBA has indicated these rows in the T1114 (aka, HPD:HelpDesk) are LOB's: C1000005940 z1D Template Related CI C1000000151 Detailed Decription C1000000156 Resolution C1000003742 z1D Mobile Worklog Upd C300270900 Reason Description All of these are character fields set to 0 (unlimited) length. The questions I have are: 1.) If a LOB is > 4K it is stored out of row regardless. Can anyone tell me how to determine the space used by any of those particular fields in Oracle? And how I can tell if these are in fact being stored out of row due to the "unlimited" option on the field? 2.) Aren't z1D fields supposed to be Display only according to Remedy's design and naming conventions? I'm pretty sure that is the case but both of the fields above with that prefix are stored as optional. Thanks in advance - William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
