Installer Tablespace or Datafile Extend Error

Trying to install formspider to both Oracle Database 10g Express Edition 10.2.0.1 and Oracle Database 11g Express Edition 11.2.0.2.0 - Beta,

For database 10g, the error is
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.SOURCE$ by 1024 in tablespace SYSTEM

For database 11g, the error is
ORA-01691: unable to extend lob segment FORMSPIDER.SYS_LOB0000029342C00001$$ by 128 in tablespace SYSTEM

What are there the workarounds for these errors of Express Editions?

asked 05 May '11, 04:19

formspider ♦♦
138●3●10
accept rate: 22%

One Answer:

oldest newest most voted

Both errors are related to the insufficient tablespace. We are currently working on adding the neccessary tablespace controls to the installer and this issue will hopefully be fixed in new release. Until then you can apply the following steps to overcome this problem:

Run this query:
select file_name from dba_data_files where tablespace_name='SYSTEM'
You should obtain the data file path from the first query. Use this path with the following command:
ALTER DATABASE DATAFILE 'the_path_from_the_first_query' RESIZE 1024M;

You may rerun the installer after these steps.

link

answered 05 May '11, 04:44

Yucel Unlu
86●2
accept rate: 25%

edited 05 May '11, 04:48

Actually, "1024M" on the statement is not a fixed value, you can decide best size for your datafile. Just dont make it below current size :). 1024M is 1 GigaByte.

(05 May '11, 04:53) Serkan Kasap...

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

install ×16
tablespace ×3
expressedition ×2
ora-01653 ×1
ora-01691 ×1