Windows

Question about a frequently changing column as primary key

Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance...

Performance degraded after changing optimizer mode

Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version - oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to...

Knowing the number of rows in a cursor

Hello everybody. Can somebody tell me if there is a way to know the number of rows returned or included in a cursor without having to cross the entire result set ? a function like "resultSetCount" or something like that ? I thought that %rowcount could work, but this returns the current row...

oracle error

Hi, pl respond urgently The following error has occured while executing a package. The following error has occurred: ORA-21000: error number argument to raise_application_error of -6508 is out of range ORA-06512: at "ECW_LOADER.CREATE_CTL_RANGES", line 154 ORA-06512: at line 19

Database Upgrade

1) I am migrating a database to 10G (from 9i) to a new server. The database is the backend for Forms and Reports (currently running 9iAS). How will moving the database to a new server, and upgrading, affect the current application server environment? Other than changing the TNS entry on the web...

Help using oracle Analytical function.

I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

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...

Restricted Groups

Hi Guys I have a query regarding the usage of restricted group in a domain enviroment. Could some pls explain the steps required to add Domain Administrator Account to the Local Administrators Groups of a node. I know this can be done but m not sure bout the steps. Please HELP!!!! Thanks Guys Asta...

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.

Cannot see entire network

hi all, i have formatted my system and installed win2kserver.wnen i tried configuring for network printer i am not able to connect to the printer.infact i am not able to access the workgroup itself in which the printer is.when i go to MyNetworkPlaces->EntireNetwork, i don't see all the...

Looking for a UNIQUE KVM Solution

I'm looking for something unusual in the way of a KVM (Keyboard, Video, Mouse) system, and have no idea where to find such a thing - so I'll describe it. In this case, I'll happily take brand names, since this would be a commercial product. As part of my business, I visit sites which are running...

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:...

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?

Setup an sms to email gateway

Required to setup an sms to email gateway so that customers can SMS the problem they face with Internet or other systems and it can be uploaded into the systems using an email.

How to disable export option in 11.5.9 thru applications.

As a security feature,we need to disable export option so that the data cannot be exported to Excel sheet directly . Is there any profile option to do so. Pls advice.

Active Directory/DNS problem in Windows 2003 network

I have just upgraded my 2 DC's to Win2003 (I totally recreated Active Directory and did a clean install). I set the first DC up with DNS which seemed to work fine. I then set the 2nd DC up with active directory integrated DNS. That seemed to work fine too and it populated itself and generally...

tutorials-2

hi all. i have sent before a message about this subject but i didnt really had real replies that helped me. i am searching of tutorials of programming (delphi, linux, perl, python, c#, java ......) i have search in google, altavista, westciv, whatis, w3school,... So if anyone now how to get pdf...

Exchange 2003 & MMIS 2002 Server ActiveSync

Currently, we are running Exchange 2000 cluster as back-end and another Exchange 2000 on our DMZ as front-end OWA server, all on Windows 2000 servers. We are also running another Windows 2000 server in our DMZ which we installed MMIS 2002 Server ActiveSync for some Wireless users. In the next...

Oracle Foreign Keys to Drop

I have a problem where I need to drop certain tables and Create replacements (schema additions/deletions to the tables). Because I have Grandfather-Father-Son table type relationships I have Foreign Keys between them. I need to drop the Foreign Keys but if I build a script to SELECT "ALTER TABLE...

Library management system

i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse