Re: does Oracle table use FILLER

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Tue, 06 Apr 1999 13:20:27 +0200
Message-ID: <3709EDFB.18A5A42D_at_vnl.nl>

 

DXLBH_at_CUNYVM.CUNY.EDU wrote:

Hi All,

   I have been worked IDMS for all these years and started to move our IDMS
system to Oracle.  In IDMS, when we defines table, we always leave some FILLER
at end of table for future uses.  Do we have to do that in Oracle database?

No - tables are generally regarded as static in form (not contents, of course!).
If you would ever to find a column is missing from a table, you can always add
it later, using an alter table statement - however, having your model right,
this should not be neccesary (just like in IDMS...)

Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV
-------------------------------------------------
Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046
  Received on Tue Apr 06 1999 - 13:20:27 CEST