| SPACE MANAGEMENT [message #156350] |
Tue, 24 January 2006 18:03  |
nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA
|
Junior Member |
|
|
Hi I have a database in which i run the following:
alter database datafile '/develop1/data.dbf resize 700M;
after that i am trying to run a job which creates the hr schema
and its objects in the database.
But my job is failing.
I am getting errors like
unable to create initial extent for segment in tablespaces
When i ran
select sum(bytes/1024/1024) from dba_Segments
where tablespace_name ='DATA';
i get 200 MB
I want this to be 700 MB
What should i do?
I don't want to add another datafile.
I want to increase the size of the tablespace to atleast 700MB.
|
|
|
|
| Re: SPACE MANAGEMENT [message #156484 is a reply to message #156350] |
Wed, 25 January 2006 06:50  |
Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay
|
Member |
|
|
The space reserved for your tablespace(I assume it only has the datafile you resized) is 700M, so it'll let you store data until reaches that size. You actually have 200M of information, as shown in the dba_segments view.
So, check the storage clause of the tables and tablespaces involved to see why it is getting out of space.
If you want, you can set autoextend on to the tablespace so automatically grows when more space than available is required.
Regards.
|
|
|
|
|
|
| Re: SPACE MANAGEMENT [message #156562 is a reply to message #156551] |
Wed, 25 January 2006 15:03 |
Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay
|
Member |
|
|
You should alter the definition of the datafile, as you've done before, enabling autoextend.(with an upper limit or not)
Check SQL Reference manual for the complete syntax.
Regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
