Re: Datawarehousing using Oracle8i over multiple servers

When you say 'servers' do you mean databases or do you mean machines - the term is a little ambiguous.

Why do you want all the data in one tablespace ? That makes it very hard to do any sort of backup.

There is a physical limit on the number of files in a tablespace and the number of tablespaces in a database , and the number of files in a database (ca. 65,000 in all cases) - so it might be a good idea to clarify the meaning of 'infinite', and the nature of the use.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

bryanhan_at_my-deja.com wrote in message <7r5u42$icc$1_at_nnrp1.deja.com>...
>Hi,
>
>I was wondering if anyone knows if you can span a one tablespace over
>multiple servers. I am trying to store files in Oracle (about 20k-2megs
>each) in Oracle instead of using a OS file system for storage because I
>need to also have searchable data fields attached to these files.
>
>I am going to have infinite records, so unlimited disk space is
>necessary... but I only want to keep this data in one tablespace, but I
>see it getting bigger than just a bunch of SCSI disks chained together.
>
Received on Wed Sep 08 1999 - 10:46:15 CDT