I am attempting to use SqlAlchemy (0.5.8) to interface with a legacy database declaratively and using reflection. My test code looks like this: from sqlalchemy import * from sqlalchemy.orm import create_session from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() engine = create_engine('oracle://schemaname:...
I have installed Oracle 10g Express Edition. When try to test the connection I am getting the error "Error while trying to retrieve text for error ORA-01019". Below is my code. strConnection = "Driver={Microsoft ODBC for Oracle};Server=Servername;Uid=username;Pwd=password;" Set conn = CreateObject("ADODB.Connection") conn....
I have a problem to start orale listiner in linux(Rhel5) I am using oracle 10g when I use $lsnrctl start there is an following error Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection...
If you have an inefficient query, and you add an index to help out performance, should the query "instantly" start using the index? Or do you need to clear out the Oracle "cache" (v$sql I believe) by running alter system flush shared_pool;? ...
is there a windows xp utility to make a database such that its support by sql server, oracle, and other db management systems. the database schema is very huge so i would like to know what to use to make it so its protable from sql server to oracle if future demands that change? ...
How to find all table references from Oracle 10G PL/SQL functions and procedures? I definitely can execute the following SQL statement: select * from dba_source where text like '%tbl_c%' but I wonder how to find all functions that call functions that refer to table used. For example I can have a function A that calls function B that...
the designing.making/deploying/management of a distributed database? or do i need to buy the versions for the above? if it 10g express has this support, will there be a central point to which my web application will connect, or do i have to write connection strings to connect to each server making "the distributed database " please al...
I am writing accessing Oracle Database via JSP/JS. I would like to know whether it is possible to set ESCAPE character with those SELECT / INSERT INTO / ... commands ? I know that "SET ESCAPE \" works under SQL Plus. But is it possible to set it through coding, so that I can make sure that the correct ESCAPE character is in us. Thanks...
We have a slow query that has a low optimizer_cost value but a very high user_io_wait_time value. Does this just indicate that there is an I/O bottleneck? Should we allocate more memory to Oracle? Get faster disks? Note: the stats were gathered by querying V$SQL ...
Access 2007 databases querying linked oracle 10g tables are returning flawed result sets when using the WHERE clause to filter-out unwanted records. Oddly, some filtering is happening, but not reliably. I can reliably demonstrate/produce the problem like this: Create a *new* database with Access 2007. Create a second *new* database w...
I have this error when running a large query on oracle. any advice? I'm using pl sql version 10.2 I have noticed that the error is due to creating a view that is based up on many tables, and when I do a select from this view to a specific parameter with a where condition I got that error. When I checked the logs I found out this o...
my spring-hibernate application run without problem for the past 1 week, but suddenly i get below error. will this caused by configuration error in applicationContext.xml? there is no error on my oracle10g log files (i get below errror every 1-2weeks once) 28 Jul 2010 14:20:19,177 INFO [http-2020-19] - Loading XML bean definitions from...
I'm working on a problem in Oracle that I'm struggling to solve 'elegantly'. I have a data extract with three different identifiers: A, B, C Each identifier may appear in more than one row, and each row may have one or more of these three identifiers (i.e the column is populated or null). I want to be able to group all records that ...
Hi all, I'm not sure if what I'm trying to do is possible. I'm calling a procedure from an APEX application (or from the SQL workshop). This procedure should write to the server using UTl_FILE. However, it doesn't work. I don't get any errors, all the appropriate messages are displayed and the updates are done. However, the output file ...
I would like to know how to do this: Environment: UNIX I would like to write a script which can be scheduled to run on a remote machine. It would read the DB details (which is residing on another machine) from a config file which looks like this: user= pass= product1_SID= product2_SID= ... Each product has its own database files. So...
I am not able to read oracle database with ddlutils and getting following error: java.lang.NullPointerException at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:573) at org.apache.ddlutils.platform.oracle.Oracle8ModelReader.readTable(Oracle8ModelReader.java:102) at org.apache.ddlutils.platform.JdbcModelR...
At any time, I want my table to display the latest 20 rows and delete the rest. I tried rownum > 20 but it said " 0 rows deleted" even when my table had 50 records.However, on triying rownum<20 - the first 19 records were deleted. Please help. ...
I'm trying to figure out a way to implement paging via stored procedure calls. For example, I have an 'Images' table that has say 100 rows. A website is going to make a request for the 'first' 12 then when the user 'goes to the next page' the site will make a request for the next 12. I'll be getting 2 in params (p_Offset and p_RecordCo...
We have data stored in oracle 10g db which contains french character set. The requirement is to read the data and generate a output file using Java. I checked the validity of the data in Oracle db via SQL*plus and it looks good. From windows: set NLS_LANG=AMERICAN.AL32UTF8 sqlplus scott/tiger sql> select billing_address from MYTABLE ...
Need to rank the below by salary, with highest salary having rank 1. RANK column shown is what I'm after. Empname sal address RANK Ram 3411 45,east road 2 Anirban 2311 34,west wind 4 Sagor 10000 34,south 1 Manisha 3111 12,d.h road 3 ...