Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Expanding Database Size
If you prefer Oracle's Enterprise Manager provides a great GUI interface that allows you to manage Oracle7 databases including adding datafiles to a Tablespace.
Billy Verreynne <vslabs_at_onwe.co.za> wrote in article
<6667c1$aqj$1_at_hermes.is.co.za>...
> Joe Schwartz wrote in message <3485be25.24059256_at_news>...
> > I created a database on an NT server (3.51) running Oracle
> >7.3. I made the database too small, so that users running a software
> >package using the Oracle engine are unable to add records. Can someone
> >please help me out with expanding the database (without, of course,
> >losing the existing data).
>
> ALTER TABLESPACE <tablespace name>
> ADD DATAFILE '<path><filename>' SIZE <size>
>
> For example, if your tables reside in tablespace USERDATA then:
> ALTER TABLESPACE USERDATA
> ADD DATAFILE 'c:\oradata\userdata02.dbf' SIZE 10M
>
> This command is fully described in the SQL Server Reference Manual.
>
> regards,
> Billy
>
>
>
>
Received on Tue Dec 09 1997 - 00:00:00 CST