Use locally managed tablespaces in oracle8i and set the autoextend feature ON
for the datafiles. The file/database will just grow 'indefinitely' to accomodate
any growth in objects (provided you have the space). The auto extend feature is
also available in oracle8 but you would have to use a dictionary managed
tablespace.
Kwabena
"Matthew Tedder" <[EMAIL PROTECTED]> on 21/03/2001 16:38:09
To: Kwabena ASARE/IBEU/HSBC@HIBM, [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: DB2 vs. Oracle
Question:
Oracle has been a royal pain in the ass for us in a couple of projects
recently done and I am considering switching to DB2. First, I need some
opinions of feasibility (or, how difficult it'll be compared to Oracle):
The database itself is on an OS/390 mainframe and the front-end is a website
based on Perl CGI scripts. Oracle required that the client software be
installed, configured, and that a text file be updated manually. Oracle tables
also do not resize themselves dynamically and our data is very dynamic, making
this a critical need. Individual Table size requirements are highly
unpredictable--growing and shrinking by wide margins in different tables each
day.
What all is involved with installing and configuring the drivers and Perl DBI
modules for DB2? Do the whole clients need to be installed as with Oracle? Do
I have to explicitly define each connection I will be making in config files for
it? (That requirement also prevents us from using Oracle for another
project--if DB2 works better, we'll be able to get rid of Oracle on the
mainframe and migrate it to Solaris for the systems that still require it).
--Matthew
************************************************************
This message originated from the Internet. Its originator
may, or may not be who they claim to be, and the information
contained herein may, or may not be accurate.
************************************************************
___________________________________________________________________________
This transmission has been issued by a member of the HSBC group ("HSBC")
for the information of the addressee only and should not be reproduced
and / or distributed to any other person. Each page attached hereto must
be read in conjunction with any disclaimer which forms part of it. Unless
otherwise stated, this transmission is neither an offer nor the solicitation
of an offer to sell or purchase any investment. Its contents are based on
information obtained from sources believed to be reliable but HSBC makes
no representation and accepts no responsibility or liability as to its
completeness or accuracy.
