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

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.