Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: need to increase the tablespace for users

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US