Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding datafile/Storage Parameters
If you want to change the default storage of the new datafiles, just do it
in two steps:
(1) Change the default storage in alter tablespace default storage (....)
(2) alter tablespace add datafile ....
HTH John Chiu
Jerry Gitomer <jgitomer_at_erols.com> wrote in message
news:80qrg9$ss2$1_at_autumn.news.rcn.net...
> Yes,
>
> The storage clause is associated with the tablespace -- not
> the datafile.
>
> hth
> jerry gitomer
>
> Chuck wrote in message
> <38303245.76063433_at_client.nw.news.psi.net>...
> |
> |
> |When you add a datafile to an existing tablespace, does it take
> the
> |current storage parameters? I am assuming so, because I cannot
> find
> |the syntax to specify this when adding datafiles.
> |
> |Thanks,
> |Chuck
> |
>
>
Received on Tue Nov 16 1999 - 05:34:28 CST