• oracle quires

    while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus

    Balachander k0 pointsBadges:
  • Oracle 10g Data Pump export through EM DB control

    When I am going to use Oracle 10g data pump export, after entering of OS user name and password and do OK, it is giving me "RemoteException Error: wrong password for the user" why this error is coming pl. give me any solution thank you

    Sr123470 pointsBadges:
  • Data Sync in tow tables

    We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the New...

    Uiiuo50 pointsBadges:
  • extract whole schema’s package hit problem.

    i need to extract the whole APPS schema packages spec and body, the problem is, there got nearly thousands of packages..it will make the my toad hung or use up all my pc memory; i can't do it with export becoz the users need it in readable format. do u hv any idea? hope somebody may help, or reply...

    Rain5forest0 pointsBadges:
  • hash Bucket–hash Partititioning

    What is the hash bucket /hash function in hash partitioning and how can we set the value for hash bucket.Could you please give me brief idea abt this?

    SatyaDBA0 pointsBadges:
  • iSupplier

    Anyone know anything about iSupplier and its relationship to ASCP?

    BarbJH0 pointsBadges:
  • Help! Does anyone know if this is true?

    Hi. The City of Atlanta is switching over to Oracle 10i. The city intends to move from 6 pay schedules to 1 pay schedule. There are 350 employees out of 9000 who would like to remain on their current pay schedule. The City claims in order to add this to the Oracle that is being installed it woudl...

    Opal0 pointsBadges:

    We are using Oralce E businees suite and the notification mgmt requires you use imap4. we are in a exchange 2003 clustered environment. what are the risk in running this service for one application to send notifications?

    Shelly990 pointsBadges:
  • SQL joins on encrypted data

    Hi - we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across...

    Tombstone7770 pointsBadges:
  • 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:
  • 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:

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.

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