Questions tagged as 'oracle11g'

4
answers

Delete thousands of records from a table

I have a table, for example, pessoa , and I would like to all people over 40 , with the script below I do this: > DELETE FROM pessoa WHERE pessoa.idade > 40; The problem that there is more than 2 million records in the table ,...
asked by 14.12.2016 / 19:42
1
answer

Problems importing cx_oracle in python 3.4 64 bits

I have a problem with cx_oracle in python 64 bit. I installed this version of cx_oracle: cx_Oracle-5.2.1-11g.win-amd64-py3.4. But when importing in python import cx_Oracle , the following error occurs: Traceback (most recent call last):...
asked by 24.05.2016 / 20:03
1
answer

Why using a column of a virtual table makes a SQL in Oracle slow

Good. Not wanting to make the subject too "gassy" but just wanted things to investigate in the environment. I have a SQL that uses a virtual table, for a series of reasons that does not come much to the case. Something like: select *...
asked by 18.01.2017 / 01:09
0
answers

Emoji JavaEE JSF JBOSS ORACLE

I have a WEB System and have been asked to put emoticons for sending e-mail. I had some problems with the database encoding that is Oracle and the NLS_CHARACTERSET was set to WE8MSWIN1252 . In order to not change the structure of...
asked by 05.11.2018 / 19:11
1
answer

Solution .Net with Membership does not connect to oracle database

I'm trying to run a project on my computer but it reports error in the string:    OracleConnection.ConnectionString is invalid The same project works normally on the computer where it was started. The Oracle version on both computers is 1...
asked by 06.07.2016 / 15:19
1
answer

Delete all objects in a schema

I have a database on oracle where I need it delete all objects from a particular Schema , I can not delete the Schema , since the system validation is done based on an algorithm that takes into account the Schema ID .     
asked by 08.03.2016 / 13:53
1
answer

TNS-03505 - ORACLE tnsping

When attempting to ping, using tnsping . ex: tnsping UMEXEMPLO I get the following error    TNS-03505: Failed to resolve name Which solution usually applies? EDIT: From other machines we normally access the Ba...
asked by 09.05.2017 / 16:41
3
answers

Return only the time in the Select

How do I return only the time in Select? I declare the time as TIMESTAMP , in this case the date and time returned, but I want it to return only the time. So I only declare DATE and now the time does not come, only comes the date...
asked by 29.12.2016 / 16:38
1
answer

How to create a query with a nonexistent table and no error

I have a query that runs on several different schemas in the database, and there is a table that specifies that some schemas have, and if the value exists, it returns. SELECT t.coluna1 ,t.coluna2 ,(SELECT coluna3 FROM tabe...
asked by 09.11.2017 / 20:31
1
answer

export import database oracle 11g sqldeveloper

The question is as follows, I have a local database, where I already have the structure and data in the respective tables that I need. I want to export this database to another machine, exactly the same structure, that is everything in my local...
asked by 24.08.2017 / 15:38