| hi, how can I extend a tablesapce? [message #368092] |
Thu, 16 March 2000 17:20  |
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  |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
