• isa server 2006

    I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable  isa client firewall externel email not working but oracle application is working fine i want working both oracle...

    Saifuddin190 pointsBadges:
  • Configuring listener.ora

    This is regarding Oracle 10g networking. On the server side I had configured listener.ora. and on the client side I had configured tnsnames.ora, but when I started listener.ora I got an error: tns name is incorrect. Could u please explain to me how to configure on Linux?

    ITKE345,295 pointsBadges:
  • query

    how to write a trigger in oracle

    Remoraghavan0 pointsBadges:
  • DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

    Mark is looking for an alternative to trimming blanks from the end of a record. He writes: "I would like to use the CPYTOIMPF command only if I can Trim Blanks from end of Record. I found out how to do this in FTP, but would really like to stay on this path and avoid FTP using Override Inputs. I...

    MichelleDavidson435 pointsBadges:
  • CPYTOPCD filename length limitation

    Hi all, Am aware of the limitation of the filename (filename.ext) for CPYTOPCD command. eg: 12345678.123 (8chars and ext 3chars). Is there any command that I could use to have my filename as follows: AA12345678.txt or AA12345678 ? Or maybe additional step that I could insert into my CL after the...

    JechLee5 pointsBadges:
  • Entering more than 45 data Selection Values in Data Selection for Version in Version List in DreamWriter

    How do I enter more than 45 values for a field (this appears to be an upper limit - with only 45 fields (15 lines of 3 fields per line) available on the display) within Data Selection Values for a Version on Version List in DreamWriter in JDE. Thank you to anyone for helping with this. 

    TonyC15 pointsBadges:
  • Data Guard implementation for Oracle 10gR2

    I am making a standby database for dataguard on 10.2.0(windows 2003 VmWare) following this tutorial. I am confused about the standby database creation. I successfully configured the PD with these steps, but I simply ran the oradim command for the standby databae creation then mounted the database...

    ITKE345,295 pointsBadges:
  • Flash Recovery Area in Oracle 11g

    What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...

    ITKE345,295 pointsBadges:
  • Oracle acquires SUN: implications ?

    What do you think will be the implications of Oracle's Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?

    carlosdl69,175 pointsBadges:
  • How can automatically execute a oracle process

    Give me the steps to create a batch file or some executable to run a oracle process (form/report) at any given time. Eg. Every day at 10 PM  

    Wimal10 pointsBadges:
  • Oracle usernames

    I have installed Oracle but when I’m starting Oracle *Plus it is not accepting the username and password 'scott and tiger' and 'system manager.' It is also not accepting these user names and passwords.

    ITKE345,295 pointsBadges:
  • About Time

    Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet  

    Checkp310 pointsBadges:
  • Send alert via email/SMS with Oracle 9i & Oracle Forms 6i

    Hi! I am using an application ,form6 as front end and oracle9i as back end. I want to sent alerts to the superiors as automail when certain data reaches the thresh hold and sent sms using certain service provider API ,to customer when certain condition is satisfied in the database. Kindly guide me...

    Binu405 pointsBadges:
  • Forms and Reports Beginners level Coding Sites

    I studied oracle forms and reports books i am developing the form through wizard only not by code but i need better site which is beginners level practise forms and reports coding i always my wishes to anyone who are helping me   Thanking You        

    Rajkumarsva25 pointsBadges:
  • MERGE using DECODE logic to control UPDATE

    MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...

    ITKE345,295 pointsBadges:
  • get a anr record from databse by using max (one Field) and orderby (one filed) desc

    Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

  • Oracle: Can a character set be changed after a schema has been created?

    My boss was so pleased with the response from this site that he asked me to ask another question!  He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!). In any case, we build a new db (schema) prior to...

    DeloeranGuy55 pointsBadges:
  • Bulk update for every 10k rown among 2L

    Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

    Praveenkc5 pointsBadges:
  • Using Multiple Oracle Homes patchset application

    Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2, patch...

    Ecv3045 pointsBadges:
  • Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export

    My boss is getting an "EXP-00091: Exporting questionable statistics." error - actually, several identical messages per table - when using the EXP utility to dump several tables in an Oracle database.  I'm not familiar with this utility, so I'm researching the problem for my boss.  The...

    DeloeranGuy55 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