Is there a way to create a dialog between SQL Server Service Broker and Oracle Streams Advanced Queuing?
Answer Question | April 26, 2009 6:25 PM
Oracle Streams, SQL Server, SQL Server Service Broker
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 188.8.131.52.0 however I don’t believe this is a supported combination and need to know what problems we may encounter
Answer Question | April 24, 2009 10:47 AM
Citrix, Oracle, Oracle 9i, Oracle Forms, Oracle Forms 6i, Windows Server 2003
I want to license 50 users (NUP) on 2 new Oracle systems (on separate servers). Because of Named User Plus minimums on each server I require: 100 NUP licenses (for server/system 1 & 50 NUP licences for system/server 2) – Total 150 NUP licenses. My question is, how should this model take into account the [...]
Answer Question | April 24, 2009 8:57 AM
Oracle, Oracle licensing, Oracle Permissions, Oracle User Profiles
how to convert excel sheet into oracle report generating tool
Answer Question | April 24, 2009 8:00 AM
Microsoft Excel, Oracle Reports
If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error”Validation error” and followed by another error message “oracle executable manager stopped working and was closed”. please what will I do? How can I create additional listener in [...]
Answer Question | April 24, 2009 12:20 PM
Oracle 10g, Oracle error messages, Oracle Validation Error
I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that’s true, then how do I run them? Is there a runtime with 10g? I feel [...]
Answer Question | March 23, 2011 8:17 PM
Converting 6i to 10g, Forms 10g, Forms 6i
I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD(‘cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL’) RMTLOCNAME(’184.108.40.206′ + *IP) RMTUSER(‘dekbf’) RMTPWD(‘ekbf’) Here is the error returned, ksh: ekbf/ekbf: not found.
Answer Question | April 22, 2009 6:46 PM
AS/400, RUNRMTCMD, SQL Loader, Unix
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Answer Question | April 22, 2009 5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
Answer Question | April 22, 2009 5:53 AM
Oracle development, Oracle Forms 6i, Time On Alerts in Oracle Forms 6i
I have over 400 records added to a table in a minute. A processed flag is set in each record as they are processed. I want to process each record exactly one time. I want to process the records in small groups with multiple processes; that may run on disparate machines. It is desirable to [...]
Answer Question | April 29, 2009 3:19 AM
Oracle 10g, Oracle 10g administration, Oracle ROWNUM, SELECT statement, UPDATE statement
What do you think will be the implications of Oracle’s Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?
Answer Question | October 29, 2009 12:35 AM
Database Management Systems, Hardware, Operating systems, Oracle, Sun Microsystems, Virtualization
We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is any communication [...]
Answer Question | April 22, 2009 11:28 PM
Oracle 10g, Oracle 11g, Oracle 8i, Oracle 8i migration, Oracle migration, Oracle upgrades
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?
Answer Question | April 27, 2009 9:16 PM
Oracle on Linux, Oracle performance, Unix Server sizing, Unix Servers
What is the procedure for importing a dmp file?
Answer Question | July 22, 2009 7:47 PM
DMP Importing, Oracle import/export
How do I create an oracle database?
Answer Question | April 20, 2009 6:06 PM
Oracle Database, Oracle database administration
I have about 25000 pages in a pdf file. I want to split this into multiple files. Please help me out to generate this using Oracle Report Builder 10g.
Answer Question | March 25, 2010 4:10 PM
Oracle 10g, Oracle Reports, Oracle Reports 10g
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!
Answer Question | May 8, 2013 6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]
Answer Question | April 20, 2009 3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?
Answer Question | April 19, 2009 8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning
queries seem get mangled by our report writer middleware; I’d like to see the actual SQL received by Oracle9i from a particular user. how?
Answer Question | April 17, 2009 5:14 PM
Oracle 9i, SQL queries, SQL Server logs