Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Getting problem while creating new work area

Posted on 2004-09-02
1
Medium Priority
?
700 Views
Last Modified: 2013-12-11

Created one user for repository with separate table space. Given that user necessary grants. Created Repository via Designer 6i (repository admin utility). I am able to logon with the created user. I enabled the version control also. I try to create one work area via Design Editor and Repository Object Navigator. I am getting the following error.

Message
-------
ORA-01086: savepoint 'RM_DISPATCH' never established

--------------------------------------------------------------------------------

Message
-------
ORA-06512: at line 18

--------------------------------------------------------------------------------

Message
-------
ORA-25153: Temporary Tablespace is Empty

--------------------------------------------------------------------------------

Message
-------
RME-02124: Failed to execute SQL statement: ! declare
utility varchar2(3);
curr_el integer;
begin
savepoint rm_dispatch;
rmmes.clear;
curr_el := 0;
RMOACTIVITY.OPEN(:p1_el0,:p2_el0);
:errcnt := 0;
exception when others then
rmmes.get_error_state(utility,:excode);
rmmes.get_product(utility,:exprod);
:exutil := utility;
:errcnt := rmmes.getsize;
:sqlcod := SQLCODE;
:sqlmsg := SQLERRM;
:currel := curr_el;
rollback to savepoint rm_dispatch;
end;

--------------------------------------------------------------------------------

Message
-------
RME-00222: Failed to dispatch operation to Repository

--------------------------------------------------------------------------------

Message
-------
RME-00223: Failed to open new activity
0
Comment
Question by:singaravadivel2202
[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
1 Comment
 

Accepted Solution

by:
ramaswamymorla earned 500 total points
ID: 11965339
Temporary table space need to bee created. After creating the temporary table space and assign to the user (repository owner). Tried creating work area and generates table and capture design of that. Found working
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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…

604 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