IT Knowledge Exchange’s iPad Contest Starts Today!
Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible [...]

Answer Question   |  January 20, 2011  4:55 PM
AS/400, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, iPads, ITKE Contests, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows, Windows Server

Are Oracle direct queries straightforward?
Hi,  Our company uses an Oracle driven database application (java through internet explorer).  At some point I can get reports in PDF for several predefined reports, but there isn’t a way to retrieve the data from Oracle to an Excel spreadsheet, for easier post-processing.  Is there any feasable way of connecting directly to the server [...]

Answer Question   |  February 16, 2011  11:18 PM
Database Application, Excel 2000, Oracle, Oracle Query, Windows Server 2003

Replicating Oracle 10g database in Oracle 9i
I have an oracle 10g database and would like to create a replica of it in oracle 9i. Could you please explaim if this is possible. I’m sure there would be backward compatibility issues to contend with.   Regards,

Answer Question   |  January 6, 2011  6:00 AM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle Database, Oracle Database Versions

Backup solutions for VMware environment
We’ve added VMware servers to our data center, and we’re looking for a backup solution that works. There will be a mix of ESX 4.0 and ESX 3.5 hosts along with vCenter 4.0 with a mix of Windows Server 2003, Windows Server 2008, Red Hat 4.x and 5.x, SQL Server 2005 and Oracle database. TSM [...]

Answer Question   |  January 3, 2011  7:57 PM
Desktop virtualization, ESX 3.5, ESX 4.0, Oracle Database, RedHat, Server virtualization, SQL Server 2005, vCenter 4.0, VMware, Windows Server 2003, Windows Server 2008

Oracle Inventory – View pending transactions
Hi, One of the users cannot view PENDING TRANSACIONS, while others can view. All  use same responsibility. What can be a reason?

Answer Question   |  January 3, 2011  2:08 AM
Oracle error messages, Oracle errors, Oracle Views

LEI Oracle replication activities
I manage to create the LEI to oracle replication activities. My problem now is that once the LEI replication process started, it will easily increase the oracle archiving log to maximum even if only 3000 records insert or update. From my analysis, I found that LEI will always tried to update all records in domino [...]

Answer Question   |  December 30, 2010  9:22 AM
LEI, LEI replication, Lotus Enterprise Integrator (LEI), Oracle

Text file size too large in Oracle Reports
I want after run report , I put 1000 pages in a text file . but the file can’t keep 1000 pages into it and only can keep 200 pages .

Answer Question   |  January 6, 2011  12:58 PM
Oracle Reports, Oracle Reports Builder, Oracle Reports Error Messages, Oracle Reports User Parameters

How to execute Crystal Reports subreports on priority base
Hi I’d created two sub reports(x,y) which uses different queries. In main report i have to call ‘x’ report first because i have to pass the grand tot from ‘x’ report to ‘y’.  How ever my two reports are calling at a time so that ‘y’ report getting wrong result because it is calling before [...]

Answer Question   |  December 28, 2010  5:07 PM
Crystal Reports, Crystal Reports Subreports, Crystal XI, Oracle

Can i use two parameter in oracle report
i want to make a report with two parameter when user select user name in one parametr other show names of all users and user select one name ane detail of that user is shown in report.or if user select any other field other parametr show data of that selected column to selected by the [...]

Answer Question   |  January 6, 2011  9:56 AM
Oracle developers, Oracle development, Oracle Reports, Oracle Reports User Parameters, Parameters

How to export the excel file in oracle
how to export the excel file in oracle

Answer Question   |  January 13, 2011  4:49 AM
Oracle, Oracle 10g, Oracle 10g administration, Windows XP

Problems installing Oracle 9i in Windows Vista
why their is a problem in installing the oracle 9i in windows vista?

Answer Question   |  December 23, 2010  1:43 PM
Oracle 9i, Oracle 9i installation, Oracle 9i installation errors, Oracle installation, Windows Vista

Oracle 10g date column
Hi All, In the below query VALUEDDATE is the date column and REGISTER is the table. wat is the use writing CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) VALUE_DATE instead of simply column name ie,VALUE_DATE [hr /> query: SELECT CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) VALUE_DATE FROM REGISTER WHERE VALUEDDATE>’09/30/2009′ —————————————————————————————————–

Answer Question   |  December 21, 2010  10:34 AM
Oracle 10g, Oracle 10g administration, Oracle 10g Express, Oracle administration

Help choosing a career path in IT Security
Hi, I need expert advice on which aspect of security to major in. I have a background in engineering, from which i switched to Oracle database. Havent worked with the oracle Database learned and the certification gained as it was tough getting the job.I am doing  my Msc in Information Security because I love security stuffs, [...]

Answer Question   |  March 2, 2011  5:16 AM
Information Security Career, Network security, Network Security Management, Oracle security, SAP security, Security careers

SOLAP in SQL 2008R2
IS there SPATIAL OLAP implementation in SQL 2008R2

Answer Question   |  December 20, 2010  9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2

How to connect Oracle forms 6i through internet
I am using forms6i application. I have 5 shops billing systems. how can connect all shops in dial up connecttion. plz reply me clearly. this is my mail id: sun_senthil2000@yahoo.com  

Answer Question   |  December 20, 2010  8:05 AM
Oracle 10g, Oracle connectivity, Oracle Forms, Oracle Forms 6i

Windows 7 & Crystal Reports 9 – Azalea’s PostNet user function Barcode dll not recognized
I recently upgraded to a new computer – with Win 7 OS After some work getting oracle ODBCs created with C:WindowsSysWOW64odbcad32.exe, Crystal 9 would not connect to oracle ODBCs correctly using the default install location [got TNS error] I had to install it at C:Crystal Reports 9 — it then worked fine. However, any reports [...]

Answer Question   |  March 11, 2011  8:13 PM
Crystal Reports 9, DLL, DLL management, Oracle ODBC Driver, PostNet, Windows 7

Value of() in SQL Server?
what is the equivalent statement of valueof() of oracle in sql server?

Answer Question   |  December 16, 2010  12:22 PM
Oracle Statements, SQL, SQL Server, SQL Server 2005

How can I connect my application server to my Oracle 10g database?
how can i connnect my application server to oracle database 10g. the applciation server have a form that can be accessable through browser(client).pls tell be the configeration that i have to do.

Answer Question   |  December 15, 2010  10:36 AM
Application Server, Oracle 10g, Oracle 10g administration, Oracle 10g Database

Log on error Oracle enterprise manager
i can log on sqlplus useing : sqlplus “sys/oracle as sysdba” but on em log on: user : sys password : oracle give me error msg “invalid passowrd”

Answer Question   |  February 6, 2011  7:40 AM
Oracle 10g, Oracle 10g administration, Oracle error messages, SQL Plus

Crystal Reports 8.5 and Oracle 9i
Hi Brothers and lovers,          I’ve tried in designing the crystal report.while designing,i used multiple columns to view the records.Here i’ve a problem in designing.the problem is , i selected the down the across in the layout of details section in the crystal report 8.5.Through this i can’t control the record to next column before [...]

Answer Question   |  December 11, 2010  3:59 PM
Crystal Reports, Crystal Reports 8.5, Oracle 9i