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

    Paulachen0 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • Reading, Deleting, Writing Rows to Oracle Data Base

    We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers in...

    Milkman0 pointsBadges:
  • Understanding SAP security risks

    What is a good resource to help me understand the risks of assigning the &NC& authorization group to a table? I am worried about these tables being accessed by "unauthorized" users? Please post your thoughts. Thank you!

    SillyITgirl0 pointsBadges:
  • Seeking white papers on .NET connector and JCo

    Where can I find white papers with information on .NET connectors and Java connectors for SAP? I have searched many Websites but I can't find the right information. Thanks for sharing your ideas.

    SillyITgirl0 pointsBadges:
  • SQL Server 2005 adoption

    My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to...

    Nbellistri0 pointsBadges:
  • SQL Query Perfomance Issue.

    Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my SQL query. I would...

    WasimAhmed0 pointsBadges:
  • 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 Archive...

    Ashishbokey070 pointsBadges:
  • 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...

    Bobkberg1,070 pointsBadges:
  • 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...

    Prativa0 pointsBadges:
  • 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 number,...

    carlosdl68,525 pointsBadges:
  • 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

    Satyam1230 pointsBadges:
  • 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...

    CBarton0 pointsBadges:
  • 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...

    Techanalyst100 pointsBadges:
  • 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...

    MithunMCSE0 pointsBadges:
  • 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...

    Xevier0 pointsBadges:
  • 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.

    Techiecat0 pointsBadges:
  • 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:...

    Ramana0524580 pointsBadges:
  • 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?

    Oadegoke0 pointsBadges:
  • Synchronization of application servers

    hi all my company has about 30 application servers,so when i want to install something i have to do it on 30 servers which is very time consuming.due to this I Need a way to update all application servers using a single installation routine. can someone help please

    Eduado0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following