Re: Newbie - Need helpl createin initial extent

From: James Petts <jpetts>
Date: Fri, 06 Nov 1998 14:24:31 GMT
Message-ID: <3643060b.268022345@firewall.celltech>

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 - 08:24:31 CST