This is usually caused by duplicates in the query specified in USING clause. This probably means that TABLE_A is a parent table and the same ROWID is returned several times. You could quickly solve the problem by using a DISTINCT in your query (in fact, if ‘Y’ is a constant value you don’t even need to put it in the query). ORA-30926: unable to get a stable set of rows in the source tables There is no disk space shortage on the server. After running the Metric Maintenance task ‘Clear staging area rejected data logs’ the ‘Recalculate metric store derived values’ job then fails with MMLoaderError log error, LoadFile command: sqlldr userid qpid8/ cogprd control ‘mmloader_request. SQL create table target(id number, name varchar2(10)); Table created. SQL insert into target values (1, ‘karthick’); 1 row created. SQL commit; Commit complete. SQL create table source(id number, name varchar2(10));
7 – ORA-30926: unable to get a stable set of rows in the source tables. Solution If you receive the message when testing database links: ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor either:. Post your question and get tips & solutions from a community of 417,141 IT Pros & Developers. It’s quick & easy. To do this, Oracle must have a unique field, or set of fields, that is shared between the incoming data that you are using to update a table and the data that is already in that table.
I have an error (ora-30926:unable to get a stable set of rows in the source tables ) in a process chain, when rolling up of agregate is performed if I launch the process chain by hand, this. The error could be either caused because of table space or because of ORACLE merge functionlaity. ORA-30926: unable to get a stable set of rows in the source tables. Title: ORA-30926: unable to get a stable set of rows in the source tables. Document ID: QCCR1H94855. Product – Version: universal cmdb 10.10 10.20;.