Re: What is real datafile size?

On tablespace creation one (1) file size 10 M is created. As soon as the allocation runs out of the 10 M, new files! are added each 512 K big. The total size of all files will be 250M. Probably those 250M are never reached because the number of datafiles will exceed the maximum allowed as specified at database creation. This looks like a documentation bug or an undesirable example.

Hth,

Sybrand Bakker, Oracle DBA

Sheng Jin <sheng.jin_at_ualberta.ca> schreef in berichtnieuws 38F7488C.CC25D8A8_at_ualberta.ca...
> Hi, When I read Oracle8 Server Administrator's Guide(p9-6), I am not
> sure for the real datafile size in following command:
>
> Alter Tablespace Users Add Datafile 'filename2' size 10M
> AutoExtend ON
> NEXT 512K
> MAXSIZE 250M
>
> [1] It seems the filename2 size can reach to 250M. What is the use of
> item 'size 10M'?
> [2] Does filename2 start to extend after it reach size 10M or from
> begin?
> [3] What is the difference of above command with the following one:
> Alter Tablespace User Add Datefile 'filename2' size 250M
>
> Any help will be appreciated!
>
> Sheng Jin
>
Received on Fri Apr 14 2000 - 00:00:00 CDT