Questions tagged as 'oracle'

Tagged questions
2
answers

Oracle Update with Join - ORA-01779

Good morning, I'm trying to do an update on a column using information from another table using ORACLE. However, I'm getting the error "ORA-01779: Can not modify a column that maps a table not preserved by the key." Following script used:...
asked by 10.07.2018 / 15:45
0
answers

Error connecting Codeigniter with Oracle

I am trying to connect codeigniter with oracle and is giving this error: Fatal error: Call to undefined function oci_connect() in C:\Apache24\htdocs\system\database\drivers\oci8\oci8_driver.php on line 238 A PHP Error was encountered Severity:...
asked by 04.07.2018 / 15:23
0
answers

Oracle conversion error

I have a problem: when I run a function direct on the database, no problem occurs but when I run in php , this error occurs:    ORA-06502: PL / SQL: numeric or value error: character to number conversion error The problem is...
asked by 29.06.2018 / 19:51
0
answers

Creation of slow materialized view

Good evening. I'm creating a materialized view based on a JOIN with 3 tables, but it's taking too long ( 200+ minutes on the machine ). I use the appropriate indexed keys in the WHERE of each table and have already given R...
asked by 29.06.2018 / 23:49
0
answers

spring boot + Oracle Connects to the bank but does not generate mapped table

Spring boot connects to the bank but does not generate the mapped tables ... In the example below, I'll put the password wrong, see the return: dataSource.setPassword("");    2018-06-29 00: 26: 46.322 INFO 13612 --- [restartedMain]   org.hi...
asked by 29.06.2018 / 05:39
1
answer

Error running .sql via .bat

The query runs fine sqldeveloper but when calling via .bat does not recognize commands like ( case, nvl,sum ) Has anyone gone through this?   'C: \ oracle \ app \ oracle \ product \ 11.2.0 \ server \ bin \ sqlplus.EXE @C: \ V1.sql'...
asked by 03.07.2018 / 22:20
0
answers

Error in SQL Server Data Migration to Oracle

I have a problem migrating the data that is in SQL Server to Oracle, using that "Migrate to Oracle" tool in SQL Developer, where it associates the data between the involved banks through a repository. > Then in the execution the data migration...
asked by 21.06.2018 / 19:33
1
answer

Create an Oracle Agent / Job for PostgreSQL

I would like to know if it is possible to create an agent / job in Oracle to query the data of a given table and insert the data of this table into another table that is in PostgreSQL. Or you can get through the PostgreSQL PGAgent to create a...
asked by 21.06.2018 / 15:34
0
answers

Oracle 11G XE change size tablespace system

I have following script DECLARE countTablespaceFile integer; BEGIN SELECT count(*) INTO countTablespaceFile FROM DBA_DATA_FILES where file_name in ('/oracle/bdond/cbiep01/bdrgt/system01.dbf', '/oracle/bdond/cbiep...
asked by 14.06.2018 / 22:12
0
answers

ORACLE SQL - Complex report

Good morning, I need to get a report that is not made available by the system, working with the invoices table. In this table there is the data of the customer, consumer unit and the value of the flow. It turns out that a customer can have more...
asked by 13.06.2018 / 14:42