EMCA
When trying to start EMCA I get the error message ‘couldnt set locale correctly’ also is it better to let EMCA build the database or should I do it.

Answer Question   |  October 14, 2005  2:42 PM
Oracle

Oracle Hash Partitioning.
Hi, In Oracle hash paritioning do we have control over hash value based on which partitioning is done? My issue is – We have to make a design for datawarehouse application and in the landing area we are planning for range-hash partitionining based on the keys (and their volumes). Now, if we use range-hash paritioning, [...]

Answer Question   |  October 14, 2005  1:06 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows

ORACLE
HOW CAN I MOVE DATA FROM EXCELL SHEET INTO ORACLE DATABASE TABLE

Answer Question   |  October 12, 2005  8:38 AM
Development, Oracle

Installing Oracle 10g on an external USB drive
I have asked this question before but got no reply. I hope I have better luck this time. I have an external USB hard drive which I can plug into either of my two PC’s. I would like to install Oracle 10g on the external USB hard drive and be able to access/use it from [...]

Answer Question   |  October 11, 2005  7:15 AM
Oracle

Why do IT projects fail?-3
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]

Answer Question   |  September 30, 2008  3:10 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support

Why do IT projects fail?-2
Hi, I’m a Computer Engineering at CSU Chico. I’m conducting a research paper on “Why IT Projects Fail”. If someone could give me an example of a failed projects, “failed” meaning that it didn’t get finished on time, or the final project did not meet the requierments. Also if you could give a quick description [...]

Answer Question   |  October 10, 2005  3:10 PM
390, Business/IT alignment, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support

Oracle 10G tuning statements
Do you know of any new tuning techniques, or things I should be aware of that have changed in version 10G in terms of tuning SQL or PL/SQL statements? Thanks.

Answer Question   |  October 5, 2005  9:44 PM
Oracle, SQL, Windows

AutoUpgrade error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors
RDBMS Version: 9.2.0.6 Operating System and Version: Windows 2003 Error Number (if applicable): ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors We are upgrading oracle database to 9.2.0.6 and apps from 11.03 to 11.5.10. while running autoupgrade, we are getting the following error: ORA-04063: package body “APPS.AD_UPGRADE_VALIDATE” has errors This is standard oracle package. Anybody experienced this [...]

Answer Question   |  September 27, 2005  9:36 PM
Oracle, Windows

Security/ Audit Check list for DB2
Hi, I’m in the process of hardening the DB2 in Linux and I’m looking for a checklist to help me make sure I don’t miss anypoint. Since I’m not an expert on DB2 I would like to have a starting point. I’m looking to make sure I don’t leave open doors and also I want [...]

Answer Question   |  October 3, 2005  12:45 PM
Application security, Database, DB2, Encryption, Exchange, Instant Messaging, Oracle, Secure Coding, SQL

ASP with Unicode records -
Has anyone displayed unicode records from sql server on web browser thru asp. my static strings are getting displayed fine but data from sql server shows junk like this…..”???” any page directive needed in asp declartions? i am using utf-8 as meta content type

Answer Question   |  September 26, 2005  7:59 AM
Content management applications, Database, DB2, Desktops, Development, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web development tools, Web services, Web site design & management

AMD vs INTEL….?
Hi all, I`ve been a AMD fan as long as i know but i have a few questions for everyone! If INTEL`s chip specifies Pentium 4 3600(800FSB 1MB)LGA 775Pinn the we all know its 3.6GHZ! But Now WHY when we get to AMD specification of chipset : AMD Athlon64 ? 4000+ (PIB) 2.4GHZ, 939-Pin Processor [...]

Answer Question   |  October 2, 2005  6:22 AM
3Com, Availability, Avaya, Bandwidth, Billing and customer care, Billing Support Systems, Cabling, Career development, Cisco, Dell, Development, Distribution/logistics applications, Enterasys, Foundry, Hardware, HEAT, Help Desk, Hewlett-Packard, Hubs, Interoperability, Microprocessors, Network management software, Network protocols, Networking, NIC, PeopleSoft, Printers, Routers, Software, Switches, Tech support

Windows or Web App for Data Update?
I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don’t know which control to use. Can [...]

Answer Question   |  September 23, 2005  4:36 PM
ASP, ASP.NET, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, OS, Programming Languages, Security, Servers, SQL, SQL Server, VB.NET, VBA, VBScript, Visual Basic, Web development tools, Web site design & management

Error ORA-00904 on Export
I am running an export command for backup purposes and receive the following error: Connected to: Oracle8i Release 8.1.5.0.5 – Production (5 user, NetWare Bundle) PL/SQL Release 8.1.5.0.5 – Production Export done in US7ASCII character set and US7ASCII NCHAR character set About to export the entire database … . exporting tablespace definitions . exporting profiles [...]

Answer Question   |  September 25, 2005  12:36 PM
Oracle

Oracle 8.1.7 Rman commands
I am trying to run Oracle 8i Rman and cannot find any explanation for the Rman command line. I can connect to the recovery catalog and the target and by using some examples of Rman run commands I can do certain things. But I need to know the commands?.. When I get an error saying [...]

Answer Question   |  October 11, 2005  11:06 AM
Database, DB2, Oracle

Enabling Java in Oracle 8.1.7 – ORA-29540
I got the error below while trying to UTL_SMTP package to send e-mail: ORA-29540: class oracle/plsql/net/TCPConnection does not exist Apparently my Oracle 8.1.7. db is missing some Java classes. Can someone tell me how to enable Java in 8.1.7?

Answer Question   |  September 26, 2005  8:55 AM
Oracle, Windows

Role Maintenance
Background: oracle 9.2.0 running on win2k I got 2 logical userids A) OPTELADMIN –given RESOURCE, CONNECT roles and owned all the user created objects such as tables, indexes, sequences, etc. This userid is shared by 3 physical developers B) OPTEL –given CONNECT,CREATE SYNONYM roles and physically shared by 4-5 end application users. End application users [...]

Answer Question   |  September 22, 2005  2:14 AM
Database, DB2, Oracle

Help with SQL
Sir, I have two tables and I need to show incoming amount from each against the range of days selected by the user. I also need to total the two amounts where the dates are the same. My database is access. TableA date amountOne TableB date amountTwo The result I want to show is eg [...]

Answer Question   |  September 23, 2005  10:06 PM
Database, DB2, Development, Oracle

ORA-04098: trigger Trigger Name is invalid and failed re-validation
Hi, I compiled the trigger in DB and tested it thru online application checkout. It worked fine. However, latter, users received an error in production environment as “ORA-04098: trigger <Trigger Name> is invalid and failed re-validation”. Is it possible that compiled trigger object go invalid at runtime because of some reasons ? Kindly let me [...]

Answer Question   |  September 28, 2005  12:56 PM
Development, Oracle

9i and 10g installation on the same server
i have 9i installed on windows 2003 server. what i need to do is to install 10g on the same server as well. so, i’d like to know if there would be any difficulties if i do so. they both have to be able to run side by side.

Answer Question   |  October 12, 2005  4:06 AM
Database, DB2, Oracle

Network neigbhorhood
Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through [...]

Answer Question   |  September 21, 2005  2:10 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP