Re: Size limit on PC version of Oracle

Graham Conway <gconway_at_mit.edu> wrote:

>Can anyone tell me what the limit is on table size in Oracle running on
>a PC under DOS? I have 5 CD-Roms worth of information that I would
>like to put into a database and I was concerned I might run into the
>DOS address limit.

I assume this is Oracle 5.1A. There is no hard limit. However the database does have a MAX_FILES parameter that controls how many data files you can have. (NOTE: datafiles are not tables! You can have an unlimited number of tables, provided you've got the datafiles to hold them. Oracle will put the data in whatever datafiles it chooses, given the behavior of TABLESPACES -- see the documentation.)

Actually, if there is a DOS file size limit, and you create an ORACLE database with a MAX_FILES setting that's too low, you could be unable to extend your database to be as big as you want. So, don't do that. ;-)

>Also, is there a stable Windows NT version of Oracle?

YES. It's called Oracle Workgroup Server. Ask for the Windows NT version. The version I have is 7.0.15.something. I think it's shipping commercially. It's supposed to be $995 for a two-user license, or something like that, but don't quote me, I don't sell them. Call 800-ORACLE-1 and ask them.

ObDisclaimer: I *do* have an indirect financial interest in Oracle's version for Windows NT, called Oracle Workgroup Server, because I'm writing a book on it.

Cheers.

 -Tom

-- 
Thomas Cox      tcox_at_netcom.com        Cox for Labor Commissioner