Re: Tablespace, Please help

Hello Erwin,

Thank for your respond.
[Quoted] I wonder, what the Autoextend Yes will do (My Question 1), will it create the new Datafile itself, or it will extend accordingly ? what are the storage parameter it will extend ?

Thanks.

[Quoted] Erwin Dondorp <erwin_at_dondorp.com> wrote in message news:39AD2D7B.42E2D6D1_at_dondorp.com...
> Johnson wrote:
> > - DATA tablespace - the free space only leave 0.13 percent, what should
 I do
> > ? The autoextend is set to Yes
> Do nothing. The autoextend will allocate all the space that is needed.
>
> > - When we create the tablespace, the autoextend clause is refer to
 datafile
> > or tablespace?
> autoextend always refers to a datafile.
>
> > - There are 3 datafiles in the DATA tablespace, all are set to
> > autoextendable YES, how the raw data are write to this datafiles.
> Oracle uses a sort of round-robin technique to allocate space in all
> the datafiles for a tablespace.
>
> > - Why 3 datafiles, can it be only 1 Datafiles
> The 3 files might reside on a different disk for example.
> This giving better performance.
> Another reason is that if one data file gets corrupted by a bad spot on
> the disk, you only need to restore and recover that (relatively) small
> file.
>
> Erwin
Received on Fri Sep 01 2000 - 10:37:16 CEST