By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

compact lob data?

P: n/a
Sue
Hi, two questions --

1. Will compacting lob data help reduce the space occupied by the lob
column and any disadvantages to doing this?
2. I have a table with a lob column that was not compacted when the
table was first set up -- is there any way I can now compact this
column without changing the table name?

Thank you very much for helping.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
See below.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Sue" <se*****@hotmail.com> a écrit dans le message de news:
11**********************@o13g2000cwo.googlegroups. com...
Hi, two questions --

1. Will compacting lob data help reduce the space occupied by the lob
column and any disadvantages to doing this? No, it has to with how the actual lob will be stored. 2. I have a table with a lob column that was not compacted when the
table was first set up -- is there any way I can now compact this
column without changing the table name? I don't believe so (if you are at V8.2.1) maybe latest fixpack will allow
you to alter table ..... column.....
HTH, Pierre.
Thank you very much for helping.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.