| Partha |
Posted: Jul 26, 2007 07:55:50 AM |
Total Post: 3
Joined: Jul, 2006
|
| Tablespace is running out of disk space. How to solve the issue?. |
|
|
 Nand |
| Posted: Jul 27, 2007 01:57:39 AM |  |
|
Total Post: 22
Joined: Jun, 2007
|
You have these options
alter database datafile <name> autoextensd on;
or
alter database datafile <name> resize <new size in Mb/Gb> ;
or
alter tablespace <tbsname> add datafile <newfile> size <size>;
|
|
|
|
|
| Jolly |
| Posted: Jul 29, 2007 10:58:20 PM | |
|
Total Post: 24
Joined: Mar, 2007
|
Hi,
If you are running out of disk space, then you can use Alter tablespace command to create a new datafile in a disk having space. Also you can give a try by resizing the datafiles.
Cheers
Jolly
|
|
|
|
|
| amol |
| Posted: Aug 02, 2007 09:13:24 AM | |
|
Total Post: 4
Joined: Jan, 2007
|
Hi,
If you are running out of disk space, then initially you have check with the MAXDATAFILES clause in the control file so that you won't get flashed with "no. of datafiles reached to its threshold" error..else you can use ALTER TABLESPACE command to add a new datafile in a disk with enough space for datafile addition. Or another way is to resize the existing data files if the space is available there on disk where datafiles are created.
|
|
|
|
|
| amol |
| Posted: Aug 02, 2007 09:13:40 AM | |
|
Total Post: 4
Joined: Jan, 2007
|
Hi,
If you are running out of disk space, then initially you have check with the MAXDATAFILES clause in the control file so that you won't get flashed with "no. of datafiles reached to its threshold" error..else you can use ALTER TABLESPACE command to add a new datafile in a disk with enough space for datafile addition. Or another way is to resize the existing data files if the space is available there on disk where datafiles are created.
Cheers !
- Amol R Tambolkar
|
|
|
|
|
| amol |
| Posted: Aug 02, 2007 09:14:28 AM | |
|
Total Post: 4
Joined: Jan, 2007
|
Hi,
If you are running out of disk space, then initially you have check with the MAXDATAFILES clause in the database creation script using backed up control file so that you won't get flashed with "no. of datafiles reached to its threshold" error..else you can use ALTER TABLESPACE command to add a new datafile in a disk with enough space for datafile addition. Or another way is to resize the existing data files if the space is available there on disk where datafiles are created.
Cheers !
- Amol R Tambolkar
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
