• Connecting to the Database

    I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that 'unrecognised database format', how can I do it then?

    Jmirror0 pointsBadges:
  • To add a column to an oracle(8i) table someplace other than the end of the list?

    Greetings, Is there a way to add a column to an oracle(8i) table someplace other than the end of the list? Thank you very much, Paula Chen

    Paulachen0 pointsBadges:
  • Database cleanup

    Background: Oracle 9.2.0 running on win2k q1: I need to find out which objects have not been in used for > 6 mths. How do i do this? q2: Before i delete an object, eg, an index, materialized view, view, i need a query to find what are its dependency, so that i would know whether this shld be...

    Mayleong0 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:
  • accessing oracle application thru internet

    currently we are using this address to login to the application within LAN http://oracle-svr.gsmsc.com:8000/dev60cgi/f60cgi what is the next step in order to let external user to log in? is it there any port i need to open on the firewall?and where should those ports pointing to? currently my...

    Pohseng0 pointsBadges:
  • Is java better thab vb ?

    what do you think about this ? is that worth to learn java or you think the future is for vb?

    Kkk10000 pointsBadges:
  • Oracle Import

    I am trying to do export from vax alpha oracle 8.1 to Linux Oracle 9i I am getting following error in Import on Linux Oracle 9i machine IMP-00010 : not a valid export file , header failed verification. Can you suggest something? I thought earlier may be file not in binary or got corrupted in email...

    Singhbb0 pointsBadges:
  • Synchronizing expired merge subscription database with publication database

    I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.

    Micjones0 pointsBadges:
  • ORACLE Question – Split data in 90 days chunk

    I need to aggregate data in 90 days chunk. For example, I have following data. Date Custorm Qty 1/5/05 1 7 3/31/05 1 9 5/10/05 1 10 I need to sum(qty) for chunk of 90 days. The chunks should be such that the first chunk starts on 1/5/05, and goes to 4/5/05 (1/5/05 + 90 Days). My second chunk would...

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

    carlosdl69,160 pointsBadges:
  • Oracle Import to Linux

    I have full export dump from Oracle database version 8i from Vax/alpha machine. I want to impoet to Linux system which has Oracle 9i installed What steps should I do?

    Singhbb0 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:
  • Deleting duplicate rows based on timestamps

    Hello.. I'm quite new to MYSQL.. I have a table with two fields : tag_in and time_in, where time_in is a timestamp field.. Some rows have the same value for tag_in.. I'd like to neaten up the database in 2 ways: 1. Delete rows with duplicate tag_in but removing the one with the oldest timestamp...

    Amateur20050 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:
  • What is wrong with my code?

    Posed on behalf of SearchOracle member Deepa: Question: How can I get a oracle database connection? Here is a code to which accepts username and password and checks for validation. is it correct? Pls tel me import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.util.*;...

    Margaret Rouse1,730 pointsBadges:
  • Need help with max function within a left outer join

    I need to search for a max timestamp of a column within a left outer join statement. I have tried many different combinations unsuccessfully.

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

    Gypsydavi0 pointsBadges:
  • ORACLE

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

    Abcd1234110 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