On Wed, 2 Jun 1999, M. HITHAYATHULLAH wrote:

> Hai Kaplan,
> 
> 	How R U?. Today  I had faced one problem. In Report Writer Ver 1.1 on
> Oracle 7.1, while I trying to copy a report in Report Writer Menu into a
> new report name, I am getting error like this
> 
> " ORA - 01653 UNABLE TO EXTEND TABLE
>   SYSTEM.SRW_TEXT_LONG BY 473 IN TABL, INSERT INTO SRW_TEXT_LONG(APPID,
> TIMEID, TYPE, PANEL, TEXT_OWNER) VALUES (:b rountinue :RWVCOP).
> 
> Please give me solution.
> 
> Thanks & Regards
> 
> M. Hithayathullah.
> 

The problem lies not in Report Writer itself but in the free space for
your TABL tablespace. The "ORA-1653" error indicates that your table,
SRW_TEXT_LONG, cannot increase in size.

To fix this, add space to your tablespace. Since you are on Oracle 7.1,
you can only do this by adding a datafile. First, see what datafiles
exist:

SQL> SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'TABL';

(various datafiles are shown)

SQL> ALTER TABLESPACE TABL ADD DATAFILE '/path/tabl05.dbf' size 250M;

Tablespace altered.

SQL>

Note that in the above command, change "path" to where the file goes and
"tabl05.dbf" to the name of the datafile that you want to add.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 300+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page index.htm"> Back to Ari Kaplan's Home Page