Solved

Error ORA-01658 with apex.oracle.com

Posted on 2011-03-25
9
989 Views
Last Modified: 2012-05-11
Hi
I am using the Oracle supplied Apex and when I try to INSERT data into a table I get this error  message "ORA-01658: unable to create INITIAL extent for segment in tablespace ..."
What can I do about it, bearing in mind that Oracle is supporting it so I can't do anything about the way it is set up ?

Thanks very much.

Barry Williams
 
0
Comment
Question by:BarryWilliams
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 35215208
This would mean that you do not have enough free space in your Oracle database to create the object you are trying to create.  You need to add space by either extending a file, or files, in the tablespace mentioned or add a new file to the tablespace.
0
 
LVL 1

Expert Comment

by:jesusaflores
ID: 35215748
Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 35215817
What do you mean "Oracle is supporting it"? Of course they support APEX, but I don't believe that's what you meant (?)

Do you mean you obtained a workspace on apex.oracle.com and your application is throwing that error? If so, make sure you didn't reach your quota.
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 1

Expert Comment

by:jesusaflores
ID: 35215952
Reflecting further on your problem:
When inserting records into Oracle database by SQL statements, creating new tables, importing backup dump into Oracle database or when manipulating tables or data in the Oracle database, the following error may occurs:

ORA-01658: unable to create INITIAL extent for segment in tablespace tablespace_name

The problem is caused by the Oracle unable or fails to find sufficient contiguous space to allocate INITIAL extent for segment being created, due to the data files for a tablespace specified in tablespace_name has become full, or there is not enough space in the datafile.

You can check if the datafiles available and used by Oracle’s tablespaces is autoextensible, and if there is any free space in the datafile by using the following query.

select a.file_id,b.file_name,b.autoextensible,b.bytes/1024/1024,sum(a.bytes)/1024/1024
from dba_extents a , dba_data_files b
where a.file_id=b.file_id
group by a.file_id,b.file_name,autoextensible,b.bytes/1024/1024

The solutions or workarounds for the ORA-01658 Oracle error include:

1.Add a new datafile into the tablespace to increase additional space by using SQL query as shown:
ALTER TABLESPACE <tablespace_name> ADD DATAFILE <datafile_name7gt; size <size>

2.Retry the transaction or process with a smaller value for INITIAL.
3.Set AUTOEXTEND on for the data file of the tablespace.
4.Increase the size of the existing datafile by using the following SQL command:
ALTER DATABASE DATAFILE <datafile_name> RESIZE newsize;

0
 
LVL 1

Author Comment

by:BarryWilliams
ID: 35218747
Hi jesusaflores

Thanks for taking the time to reply.

As I said, I am using apex.oracle.com.
When I try to run your code :-
select a.file_id,b.file_name,b.autoextensible,b.bytes/1024/1024,sum(a.bytes)/1024/1024
from dba_extents a , dba_data_files b
where a.file_id=b.file_id
group by a.file_id,b.file_name,autoextensible,b.bytes/1024/1024

I get this error message:-
 ORA-00942: table or view does not exist

Barry






0
 
LVL 1

Author Comment

by:BarryWilliams
ID: 35218825
Hi gatorvip

Thanks for taking the time to reply.
Unfortunately your answer was not helpful because you told me what to do but without telling me how to do it.
I said  "I am using the Oracle supplied Apex" and explicilly mentioned apex.oracle.com.
Therefore I assume I cannot do any DBA-type things.
Is this correct ?

For the record, my experience with Apex compares very badly with Salesforce.com where things  just work the way you expect them to.
This kind of basic problem is amateurish and arrogant and makes me wonder if Oracle is serious about Apex.

Barry


 
0
 
LVL 20

Expert Comment

by:gatorvip
ID: 35219429
>>Therefore I assume I cannot do any DBA-type things.
>>Is this correct ?

This is correct.  You can administer your workspace, but do not have DBA-type access to the underlying engine.

>>For the record, my experience with Apex compares very badly with Salesforce.com where things  just work the way you expect them to.
>>This kind of basic problem is amateurish and arrogant and makes me wonder if Oracle is serious about Apex.

I think you might have misunderstood what apex.oracle.com is. It is NOT a production environment and in fact their front page says the following:

  Oracle provides apex.oracle.com as an evaluation service free of charge

One of the signup pages also specifies:

  This service is for demonstration purposes only. Use of this system to store sensitive data is prohibited.

They provide apex.oracle.com as a way for you to evaluate APEX and to test your application(s) against a standard, up-to-date installation. If you want to pursue APEX further, you can deploy it in your own environment or you can purchase hosting from a third-party.

I just went through a mock signup process for a workspace on apex.oracle.com and the maximum space allowed at signup is 50 MB. You can request more storage (though it's very limited) by signing into your workspace, then going to Administration / Manage Services / Make a Service Request. Then check the box for Request Storage, select the extra amount needed from the dropdown list, then confirm the request. From the administration tab you can also find out how much space you are currently using.
0
 
LVL 1

Author Comment

by:BarryWilliams
ID: 35228245
Hi gatorvip

Thanks for your response.

Oracle is missing an opportunity with its current attitude.

I would appreciate any recommendations for third-party Apex hosting.

Regards

Barry
 
0
 
LVL 20

Accepted Solution

by:
gatorvip earned 500 total points
ID: 35233874

>>I would appreciate any recommendations for third-party Apex hosting.

Oracle has a list of companies here, they provide managed hosting:

http://apex.oracle.com/pls/otn/f?p=24793:11:0

I have never used any of them, so I can't provide any feedback.

Amazon also has a pretty good platform if you want to manage your own instance on their servers. Check out this whitepaper: http://www.oracle.com/technetwork/developer-tools/apex/apex-and-amazon-cloud-169066.pdf

0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question