Re: Newbie: Max no. of fields?
From: S. Kannan <skannan_at_cardinal.fs.com>
Date: 1995/06/08
Message-ID: <3r5mts$l0_at_cardinal.fs.com>#1/1
Date: 1995/06/08
Message-ID: <3r5mts$l0_at_cardinal.fs.com>#1/1
Mr Robert J Canner (rmjdrjc_at_rs6-svr-1.pubhealth.ucl.ac.uk) wrote:
: What is the maximum number of fields Oracle will handle
: in one table/database?
: I currently use dBase/Clipper/FoxPro which often
: give me limits of about 128 or 256 fields.
: I would like to have several hundred or several thousand
: fields . . .
: Robert Canner
Hi Robert,
Oracle will handle from 1 to 254 columns/table (ORACLE7). I don't think there is any limit to the number of tables that can exist in a database. It depends on the amount of disk space you have.
You can have several hundred or several thousand fields, but NOT ALL in one table.
Hope this answers your query.
Regards
-- --------------------------------------------------------------------------- Kannan Email: skannan_at_fs.com The above are my own comments and opinion. They do not purport that of anybody else. ---------------------------------------------------------------------------Received on Thu Jun 08 1995 - 00:00:00 CEST