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: ORA-01547: failed to allocate extent size of 95 in tablespace 'SYSTEM'

Re: ORA-01547: failed to allocate extent size of 95 in tablespace 'SYSTEM'

From: Rick Henry <rhenry_at_ac-technologies.com>
Date: 29 Nov 1998 14:09:46 PST
Message-ID: <Pine.LNX.4.05.9811291405130.31624-100000@ensemble.ac-technologies.com> 





This is an example of resizing the user tablespace:
ALTER DATABASE DATAFILE



'/u1/oradb10/product/8.0.5/dba/orcl_user_01.dbf' RESIZE 100M;



Resizes it to 100 meg.



HTH



Rick






On Sun, 29 Nov 1998, Ewa M. wrote:



> could you please drop some example of how to resize the tablespace? - I


> would be interested to know the syntax..


> TIA



> REgards,


> Eva


> 


> 



Received on Sun Nov 29 1998 - 16:09:46 CST












Original text of this message













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