Questions tagged as 'oracle11g'

Tagged questions
0
answers

Passing of cpf as a parameter in an insert / select

I have a process of creating a table that is very slow and would like to improve it. The view used in the process was created to use the CPF as a parameter, but when it is executed without the CPF or in join with another table it is extremely...
asked by 26.03.2018 / 23:42
0
answers

Oracle - Lock that prevents SELECT

Lock that prevents SELECT The situation is as follows: An ERP application (Totvs) with several tables All these tables use as primary key a default field R_E_C_N_O_ The application (I believe) creates a new record common select max (R_E...
asked by 13.03.2018 / 21:16
0
answers

Problem installing Oracle XE and PHP 7 on Windows 10

I'm having trouble resolving this installation. Does oracle support for Win10? I tried several forums and I could not. I'm using DLLs directly from pecl. But I always have the same error: PHP Warning: PHP Startup: Unable to load dynamic li...
asked by 27.02.2018 / 19:55
0
answers

How to do a query using Oracle.Managed.DataAccess in C #

I have the following method in C # public static ProdutividadeBean GetProdutividade() { Console.WriteLine(CairuUtils.UserContext.getCodUsuario()); String strConnection = "Data Source=(DESCRIPTION=(ADDRESS=(PROTO...
asked by 14.02.2018 / 21:35
0
answers

Error in executing JOB in Oracle

I have a job that calls a procedure to generate a text file with all the names of employees in a company: job code: BEGIN BEGIN SYS.DBMS_SCHEDULER.DROP_JOB('job_criarquivo'); EXCEPTION WHEN OTHERS THEN NULL; END; dbms_sch...
asked by 09.02.2018 / 00:55
0
answers

Error generating file in oracle plsql

When I try to generate txt file I get the directory error message. Code CREATE OR REPLACE PROCEDURE CRIARARQUIVOTXT AS Arquivo_saida UTL_File.File_Type; Dir_Arq VARCHAR2(60); Cursor cur_arq is Select f.NOME linha from tfunciona...
asked by 09.02.2018 / 01:14
0
answers

I can not do the load test

I'm doing a load test on an Oracle database using Swingbench software. The problem is that I can not create the load the wizard runs into several exceptions and I do the step by step as it asks for the documentation, I would like a help because...
asked by 29.01.2018 / 04:05
0
answers

Simultaneous connections oracle and mysql

What is the limit of MYSQL and Oracle concurrent connections today? What are the limitations of the mysql community version?     
asked by 31.01.2018 / 13:32
1
answer

How to create a JOB in ORACLE for backup?

Good afternoon guys! I'm still new to the subject when it comes to sql, I'd like to know how to create a JOB (or another operation that does the same) that performs a data extraction from a table to a .sql file in a directory I set . If it...
asked by 17.01.2018 / 14:55
1
answer

Why can not I create a tablespace?

I'm trying to create a tablespace in oracle 11g but I can not seem to point out the error in that image: I wanted to understand why I can not create!     
asked by 24.01.2018 / 16:17