• Error on installing Oracle 10 software where Oracle 9i software already exists

    Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...

    Wbuker0 pointsBadges:
  • Free Chapter – Oracle on Linux, Analyzing Server Performance

    Another free chapter download is available on the IT Bookworm Blog. Written by: Darl Kuhn, Charles Kim and Bernard Lopuz Book: Linux Recipes for Oracle DBAs Overview: “Linux Recipes for Oracle DBAs is an example-based book on managing Oracle Database in a Linux environment. Covering commonly used...

    BrentSheets6,950 pointsBadges:
  • Regarding Oracle connectivity issues

    I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the...

    Vabene0 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • Query to get Oracle object changes

    I need to obtain a listing of Oracle object changes that have occurred during the year. Does someone have a query that I can use?

    montymonty5 pointsBadges:
  • How to insert/delete/update data into VIEW using forms 6i

    i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?

    Mohan24835 pointsBadges:
  • How to search a base64 clob image from Java in a Oracle DB?

    I retrieve a very long string image in base 64 and need to search for duplicates in another database. How can I do that?

    wilarz8930 pointsBadges:
  • View .pdf file from Oracle Forms 10g

    Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...

    NasoTang5 pointsBadges:
  • What’s the better certification: Oracle or SAP?

    Currently, I'm doing a job in the telecom sector as a RF engineer. My career growth is zero. What's the better decision: SAP or Oracle certification?

    shah4455 pointsBadges:
  • Java Oracle certification?

    What is Java Oracle certification?

    zokizo5 pointsBadges:
  • how delete 12,33,200 rows in oracle table

    how delete 12,33,200 rows in oracle table

    Shindetanaji10 pointsBadges:
  • Oracle 11g database: Drop and recreate the GTT, speed improves

    When we drop and recreate the GTT in our Oracle 11g database, the speed improves. Why is that happening?

    leenagala5 pointsBadges:
  • Oracle Apex IR subscription

    I have configured apex instance to use SMTP email, and I can send email with IR when using download option from action menu. But the IR subscription is not sending emails. I have checked there is no record on APEX_MAIL_LOG and APEX_MAIL_QUEUE. Any idea how to troubleshoot problem?

    vaha2fer5 pointsBadges:
  • What Exactly is Oracle Database

    When people talk about a company buying Oracle's database, I do not fully understand it. Does Oracle have a large database they created and now sell to companies and companies basically "fill in" the information into various tables that they will use? Does Oracle have different sized databases that...

    tennisgirl7085 pointsBadges:
  • Dependent Sublist dropdown

    Is it possible to create dependent drop down fields in sublist. For an instance I have primary categories like travel, ofc,others in one drop and based upon the selection of first field it should populate values into second drop down field. If user selected travel, second drop down should be...

    saisaranya0615 pointsBadges:
  • ASFU licensing

    When implementing PREMIA solution, is ASFU the best way to go as opposed to EE Perpetual licensing? This considering that QV is gonna be an integrated system, along side other application systems. Which one is more economical with enhanced functionality

    KIM20185 pointsBadges:
  • Need help on Oracle SQL formulation

    I have a requirement where data is as below: ID            Date                 Comments 101         23/Jun/2018      RR: Insufficient resource 101         23/Jun/2018      Next week apply for leave 102         22/Jun/2018      NULL 103       ...

    shr12345 pointsBadges:
  • Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

    When I'm compiling a package, I'm getting below error. Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure. I'm using is Oracle 11g in SQL Developer.

    Vimalkv15 pointsBadges:
  • How to find host name?

    How can I find my host name?

    Rcongo10 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.

Following