• Tracing on Oracle 10

    Hi, In order to get tracing info on Oracle 9 I added the following to the SQLNET.ORA TRACE_UNIQUE_CLIENT=on TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = C:\Oracle10Run TRACE_FILE_CLIENT = SQLNetTrace TRACE_TIMESTAMP_CLIENT = ON This worked fine and generated the relevant trace files. When I...

    Eg0 pointsBadges:
  • i want to get updated or deleted or inserted views from last four days

    sir, How can we find views which are got manipulated(DML) from last four days or one week.

    Maneswar15 pointsBadges:
  • Dell Laptop NIC not showing up

    I hace had to wipe and reload windows XP pro on a school Dell Latitude d510. After, the default NIC doesn't show up in network connections, only the firewire adapter. After installing drivers from Dell, the wireless NIC shows up. I can't find any drivers from Dell for the NIC and I don't know why...

    HornetITguy0 pointsBadges:
  • what is normalization

    what is normalization

    982750 pointsBadges:
  • Standard Oracle Login and Password for “ADP PC Payroll For Windows”

    Hi, I am mirgrating an old ADP Oracle system, and the new DBA does not know the Oracle login and password to the ADP system. Has anyone worked with this system, and do you know the stanadrd Oracle login and password to this ADP version? ADP has not been helpful since the customer left them (but the...

    Twincalicos0 pointsBadges:
  • Oracle Question

    I have just started working with a client who has had a large database application written in oracle. The application has been mirrored onto a training server with a small amount of data. I would like to create 4 different training databases on the same server (after a server upgrade) with a...

    Chrisgee0 pointsBadges:
  • odbc access error…….

    Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear :...

    Aliyani265 pointsBadges:
  • Find student whose attendence is less than 75%

    Find student whose attendence is less than 75% in subject AC? select k.studentID, k.PercentageAttd from ( select a.STUDENTNO as studentID, (select count(PRESENCE_K)*100 from attendence b1 where b1.PRESENCE_K='P' and STUDENTNO=a.STUDENTNO and subject_k = 'AC')/ (select count(PRESENCE_K) from...

    NavinT0 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

    Sprevost5 pointsBadges:
  • outer join issue

    Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to provide a...

    Hosrow0 pointsBadges:
  • Cannot get iSQLPlus to work

    I successfully installed Oracle 9i on my home machine. SQLPlus works well but I prefer to use iSQLPlus. When I try to run isqlplus I get the message 'Internet Explorer cannot display the webpage. I have tried the following ports: http://<machine name>:7778/isqlplus http://<machine...

    Jasman0 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • convert query results to excel format

    Hi, I am trying to query users with more than 4 transactions in the past quarter and bring up their address so the marketing department may send out osme mail to them. I am however told that our publishing hose wants these address in excel format. How do I convert/store the query relts into excel...

    Nanditha0 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • Lotus Domino Database Structure

    Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler

    Mirkia0 pointsBadges:
  • Special Characters getting Replaced

    Hi While inserting from java jdbc in to oracle clob data type special characters are getting replaced with ??? my database details as such NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_CSMIG_SCHEMA_VERSION 3 NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA...

    GopiRamanujam0 pointsBadges:
  • how to interconnect sql server with remote oracle server

    I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.

    Saahil0 pointsBadges:
  • Windows Server 2003 Web Edition Configuration

    I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from Frontpage...

    FlyNavy0 pointsBadges:
  • Oracle Database Issue

    Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on top it...

    Newkipper0 pointsBadges:
  • Visual Basic 2005

    My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do I do this ???

    Genius260 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