Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie - Need helpl createin initial extent
How do you figure how to configure the extents properly when doing this
command??.. ThanksDan
James Petts wrote:
> On Fri, 06 Nov 1998 13:55:13 GMT, bmolish_at_btsquared.com wrote:
>
> >I have tried the following and keep getting an error "ORA -02140 invalid
> >tablespace name'
> >
> >alter tabsespace 'g:\fox\BTS1_fox1.dbf' add datafile 'g:\fox\bts2_fox2.dbf'
> >size 200M autoextend on next 1024K maxsize 300M
>
> What's going wrong is that you are specifying the DATAFILE name, not
> the TABLESPACE name in the ALTER TABLESPACE command.
>
> What you need is:
>
> ALTER TABLESPACE BTS1_FOX1 ADD DATAFILE 'g:\fox\bts2_fox2.dbf'
> SIZE 200M AUTOEXTEND ON NEXT 1024K MAXSIZE 300M
Received on Fri Nov 06 1998 - 21:58:35 CST