Re: need to increase the tablespace for users

From: Neilc <neilc-olops_at_btinternet.com>
Date: Fri, 3 Sep 1999 16:06:00 +0100
Message-ID: <7qoo7u$38t$1@pheidippides.axion.bt.co.uk>

you can either add another datafile to the tablespace using svrmgr

ALTER TABLESPACE X ADD DATAFILE 'datafilename' SIZE 100 M

where x is the tablespace name and 'datafilename' is the full path and name of the datafile you wish to add.

or, if using version 7.2 or greater you can resize and existing datafile (assuming the filesystem / disk) can support the increase) by using

ALTER DATABASE DATAFILE 'datafilename' RESIZE 1000 M

replacing the 100 M or 1000 M with the size in Megabytes (use K for kilobytes) you require.

madhu wrote in message <_lRz3.3578$qY3.124217_at_newscontent-01.sprint.ca>...
>hi,
>
>I need to increase the table space for the users.
>
>how do I do it.
>
>madhu
>
>
Received on Fri Sep 03 1999 - 10:06:00 CDT