I have a script that is using DBI to interface with Oracle, but I keep getting the following error: install_driver(Oracle) failed: Can't load '/usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/Oracle/Oracle.s o' for module DBD::Oracle: dlopen: /usr/opt/perl5/lib/site_perl/5.005/aix/auto/DBD/Oracle/Oracle.so: can't load libra...
Hi Guys, i'm developing a 32bit Client-Application with Delphi. From this application I need to connect to databases on two different servers. First databse character set ist WE8MSWIN1252, the other server decodes with WE8PC850. Setting the client NLS_LANG parameter to the correct value solves correct sql-query results. Unfortunately t...
I have a requirement where I want to rename a column. In in this case, it should happen like: 1.) I need to create a new column with the existing column structure. 2.) Migrate the data to the new column. 3.) Retain the old column. I don't have the new column structure and I have to take it from the old column. TIA. ...
I want to learn oracle and that is why I want to install Oracle on my vista machine. Could you please let me know where can I download the installer from? Could you guys let me know about any books that I can start working with Oracle? Thank you. ...
Looking for tools (windows platform) to genereate ER diagram (or similar) from an existing Oracle database. Any good tools out there that are free to use or low cost? ...
Hi, I am trying to propagate messages between two queues that are in the same database. I did exactly as it says here: askanantha.googlepages.com/Oracle_AQ-Example-MultiQueue.pdf The message is propagated successfully. The problem is that it doesn't to dequeue the message with the default subscriber of the destination queue. The only ...
If a WSRP portlet displays a jsp page that references a css file which references an image, the image can't be loaded because the url in the css can't be found. The url in the css is a relative one: ../images/image.gif. Details of my problem I have developed a JSR168 portlet (Java Portlet Standard) and I want to deploy it in Oracle Web...
We've got an ongoing issue where php 5.2.6 will quit connecting to Oracle 10.2.0.4.0. We can go weeks without any issues and then (usually Saturday mornings) php will no longer be able to connect. The database is up and running and we can connect to it manually with varous DB tools but php won't ever connect again until we reboot the web...
Is there any way to create trigger using OCI API? I need to perform the following actions programmatically: CREATE OR REPLACE TRIGGER tbl_trigger BEFORE INSERT ON tbl FOR EACH ROW WHEN (new.id IS NULL OR new.id = 0) BEGIN SELECT tbl_sq.nextval INTO :new.id FROM dual; END; / ...
One of the pitfalls in Oracle is the fact that sometimes you can select from a table if you run a query in SQLplus but that you can't when running the query from a stored procedure. In order to run a query from a stored procedure you need a direct grant for the object and not a grant obtained through a role. If I see a table in the all_...
I get the following exception when deploying a JSR 286 portlet into Oracle WebLogic Server 11g (to deploy it later in Oracle WebCenter 11g): <19-ene-2010 13H32' CET> <Error> <oracle.portlet.server.containerimpl.PortletApplicationImpl> <BEA-000000> <Error al procesar el archivo "/WEB-INF/portlet.xml" en la lÝnea 6 columna 68. org.xml.sax...
We have an existing database link in an Oracle database that links to data in a Sql Server database. Now, a 2nd Oracle database needs to use that same data. Due to security setup, the 2nd Oracle database cannot "see" the Sql Server database, but it can see the 1st Oracle database. If we create a database link in the 2nd Oracle datab...
I tried to create a foreign key on one of my tables, referencing a column of a table in a different schema. Something like that: ALTER TABLE my_schema.my_table ADD ( CONSTRAINT my_fk FOREIGN KEY (my_id) REFERENCES other_schema.other_table(other_id) ) Since I had the necessary grants, this worked fine. Now I wonder if there...
I have a constraint called users.SYS_C00381400. How do I find what that constraint is? Is there a way to query all constraints? ...
Can someone look at the linked reference and explain to me the precise statements to run? Oracle DBA's Guide: Creating a Large Index Here's what I came up with... CREATE TEMPORARY TABLESPACE ts_tmp TEMPFILE 'E:\temp01.dbf' SIZE 10000M REUSE AUTOEXTEND ON EXTENT MANAGEMENT LOCAL; ALTER USER me TEMPORARY TABLESPACE ts_tmp; CREATE UN...
http://pastebin.com/m24c4f508 --any help would be appreciated ...
Hi, I'm currently working on a Datawarehouse project using an Oracle Database, Oracle Data Integrator, Oracle Warehouse Builder and some Jython thrown in for good measure. All of which is held within TFS. My background is .net and prior to this project was seeing a lot of promise in CI. I'm not suggesting that the testing element of CI...
Hi, I have spooled a file before running the below command and got the output like this, I have set heading off, feedback off SET HEADING OFF SET FEEDBACK OFF SPOOL D:\TEST.TXT SELECT SYSDATE FROM DUAL; SPOOL OFF OUTPUT in TEST.TXT: SQL> SELECT SYSDATE FROM DUAL; 20-JAN-09 SQL> SPOOL OFF How can i remove the two SQL> lines. I wan...
Hi, I need help about a query in oracle 10g, Here is my question: There is a table that stores signal statuses that come from different devices. SS1 and SS2 signals are inserted to table in random times, if one of SS1 or SS2 signal status is "up" then the result signal should be "up" if both SS1 and SS2 signal statuses are "down", th...
Hi, I have an web application which uses Oracle.DataAccess.dll to communicate with and Oracle db. The web application deployed on 32 bit windows system works but not on windows server 2008 64 bit. I installed 10204_vista_win2k8_x64_production_db package, referenced the installed dll (version 2.102.4.0) from the project but I get the fol...