Re: max size of datafile

From: Michael Bierenfeld <michael.bierenfeld_at_atmiralis.de>
Date: Mon, 07 May 2001 12:56:21 +0200
Message-ID: <3AF67F55.920B5A49@atmiralis.de>

andy wrote:
>
> I have an Oracle 7.3.4 database under Sco Unix Openserver 3.2 5.0. The
> db_block_size parameter is set to 2048.
> What is the maximum size reachable of one datafile?
>
> Thanks in advance.
>
> Andy.

Hi,

I can remember it is 2 Gig. But dont stick to that. You can test it with :

create tablespace ts_test datafile '/tmp/test.dbf' size 2000 M;

Increase till you receive an error :-) But dont forget to drop the tablespace afterwards ;-)
Btw. dont delete a *.dbf file when the db is running.

Regards

Michael Received on Mon May 07 2001 - 05:56:21 CDT