• Validation error in Oracle10g

    If I try creating additional listener. It will opt for my OS credential(system username and password) and each time I enter it, it will give me this error"Validation error" and followed by another error message "oracle executable manager stopped working and was closed". please what will I do? How...

    TUMUCH5 pointsBadges:
  • Oracle EE Named User Plus Licensing

    I want to license 50 users (NUP) on 2 new Oracle systems (on separate servers). Because of Named User Plus minimums on each server I require: 100 NUP licenses (for server/system 1 & 50 NUP licences for system/server 2) - Total 150 NUP licenses. My question is, how should this model take into...

    Davidpbarrett5 pointsBadges:
  • Is the Oracle client 9 compatible with Forms 6i

    We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don't believe this is a supported combination and need to know what problems we may encounter

    Dizzy5 pointsBadges:
  • Query for tab canvas block

    I have a Form with a tab canvas for the detail and a multi row master block. when scrolling through the rows in the master block the detail block (tab canvas) isnot executing the query (only by steping on the detail block is the query preformed)

    Ifatgat5 pointsBadges:
  • excuting sql loader from runrmtcmd from as400 to unix

    I am tryint to execute a sql loader process on a Unix machine from the AS400. Here is the code, RUNRMTCMD CMD('cd /home/dekbf/e3data;$sqlldr ekbf/ekbf + control=EPINTORD2CTL.CTL') RMTLOCNAME('191.0.0.9' + *IP) RMTUSER('dekbf') RMTPWD('ekbf') Here is the error returned, ksh: ekbf/ekbf: not found.

    Rzierler5 pointsBadges:
  • Oracle SQL question

    I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't like...

    Wanderer95775 pointsBadges:
  • Oracle Communication between 11g and 8i

    We are considering upgrading one of our database from 8i to either 10g or 11g. We know currently that the 10g client is compatible with 8i communication because we have two performance tools database(GRID and I3) which are 10 and they appear to have no issues. However we were wondering if there is...

    Kantermark5 pointsBadges:
  • Would like to upgrade to 10.2.0.4 from 9.2.0.7

    Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks

    Kanif15 pointsBadges:
  • Multiple Tables to Bulk Import .sql script

    I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple...

    ADMIntegrated5 pointsBadges:
  • Can I run Seconds on an Alert in Oracle Forms 6i

    I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.

    SuperRad40 pointsBadges:
  • Database

    How do I create an oracle database?

    PSS10 pointsBadges:
  • automatic go next field without enter keyboard key oracle form 6i

    hi , i facing problem with oracle 6i form ,what is the code for automatic go next field without enter keyboard key (not build in like go_item(xxx) or next_item) my code is working only when ENTER key pressed but i don't want press key, i using form for get external data from other database it will...

    Kutub50 pointsBadges:
  • How to config iSQL Plus on computer without a domain

    Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...

    DerrickOra5 pointsBadges:
  • linking report to form by macro

    I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

    Mjward755 pointsBadges:
  • Does something similar to Oracle’s optimizer hints exist in SQL Server ?

    In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc... Does something similar exist in Microsoft Sql Server ?

    carlosdl69,920 pointsBadges:
  • log sql queries?

    queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?

    Ktpierce5 pointsBadges:
  • Oracle 6i How to Save the Value of a Parameter so that next time when report runs it uses the last given Value

    Dear All Hope that you all will be at the best of your health and job,,,,, I have made a report in Oracle 6i. and given the options to user so that he can show/Hide a colum on report at run time... by passing a parameter with values Show and Hide..... if the user makes a colum Hide then that column...

    Cutejut10 pointsBadges:
  • Label in oracle

    I have heard of local labels in oracle, do we have something called public labels?

    Nilesh197910 pointsBadges:
  • HOW TO SAVE DATA FAST

    I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad's save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case...

    VEERRELIANCE10 pointsBadges:
  • Variation in space occupied in same TABLSPACE by equally populated tables.

    I am inserting data in table T2 from T1(INSERT INTO T2..SELECT..FROM T1..). Both tables are in same tablespace. Even though records in T2 are less than T1,size occupied by T2(12 GB) is much higher than T1(440 MB). WHat may be the reason(s)?

    DBDEV5 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