Home » RDBMS Server » Server Utilities » hi, how can I extend a tablesapce?
hi, how can I extend a tablesapce? [message #368092] Thu, 16 March 2000 17:20 Go to next message
xiaoliang
Messages: 6
Registered: March 2000
Junior Member
when I try to install a software of Cisco. It failed and told me:
Total free space in CISCOTABLESPACE tablespace is 142 MB. Minimum 150 MB is required.
How can I extend a tablespace?
Re: hi, how can I extend a tablesapce? [message #368093 is a reply to message #368092] Fri, 17 March 2000 05:52 Go to previous messageGo to next message
Thierry Van der Auwera
Messages: 44
Registered: January 2000
Member
Hallo,

It is not difficult.
First, every tablespaces has one or more underlying datafiles. I will use an example here for me as 'D:\oracle\db1\data\cisco1.ora'

So you can do the following:
ALTER DATABASE DATAFILE 'D:\oracle\db1\data\cisco1.ora' AUTOEXTEND ON NEXT 25M;
(This puts autoextend on)

or you can

ALTER TABLESPACE "CISCOTABLESPACE" ADD DATAFILE 'D:\oracle\db1\data\cisco1.ora' SIZE 50M;
(This adds a new datafile of 50Mgbyte to the tablespace)

Hope this is it.

Greetings,

Thierry.
Re: hi, how can I extend a tablesapce? [message #368099 is a reply to message #368092] Wed, 22 March 2000 10:54 Go to previous message
Phil P
Messages: 5
Registered: February 2000
Junior Member
Better yet:
alter database datafile '/path/file.dbf' resize 200M;

This way, you don't have to run
alter database backup controlfile to trace;
because you've added a file and you don't have to worry about a datafile filling up a disk.
Previous Topic: Recovery error with EBU and Legato NetWorker
Next Topic: Re: Importing problem V7 to V8i
Goto Forum:
  


Current Time: Mon May 23 21:40:39 CDT 2022