Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Text Compression

Re: Text Compression

From: tabreaz <tabreaz.2a3iy0_at_no-mx.forums.yourdomain.com.au>
Date: Tue, 27 Jun 2006 23:32:10 -0500
Message-ID: <tabreaz.2a3iy0@no-mx.forums.yourdomain.com.au> 






If your ultimate requirement is to compress the table data, then better
use the following option:



Create table <<tabl_name>>


pctfree 0 


compress


as select * from <<old_table>>



-- 
tabreaz
------------------------------------------------------------------------
tabreaz's Profile: http://www.dbtalk.net/m473
View this thread: http://www.dbtalk.net/t315944


Received on Tue Jun 27 2006 - 23:32:10 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US