• CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g :

    Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g : Current Environment : Operation System : Window NT4.0 Oracle : 8i (8.1.7) Developer 2K : Forms 6.0.5.33.0, Report 6.0.5.33.0 We have ERP System in house Developed. Everything working fine. Now we want to Migrate Oracle 8i (8.1.7) to...

    Swatis0 pointsBadges:
  • ORA-03113 error while compiling Oracle packages

    Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and...

    Boball0 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,175 pointsBadges:
  • Alternate way to stop Oracle Services on Win 2K Server-2

    Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup...

    carlosdl69,175 pointsBadges:
  • Database Replication

    Hello, i have to set up an Database Replication for both read and write access to a tables data from anywhere. Who knows a good description with an example for the set up and administration?

    Mysterky0 pointsBadges:
  • ora-1555 during data purge

    We have a PL/SQL script that selects then purges data from a table row-by-row. We populated our Test environment with production data, ran it, and it worked fine. When we moved it to production and ran it against the same data, it failed with an ora-1555. We've set up a large rollback segment, and...

    Mljsher0 pointsBadges:
  • Uninstalling Oracle 9i products from a Window Server

    Hello how is everyone today? When your removing all Oracle components and services from a Windows 2003 Server what method is used more. The manual method or using Universal Installer? Can you please provide me a link to white papers that take me through the process of using the Universal Installer...

    Bobby40 pointsBadges:
  • Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)

    Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?

    Rdocena0 pointsBadges:
  • Support of Oracle 8 and 9i

    We currently support several systems running Oracle 8 that are upgrading to 9i. From a support perspective, can someone help me identify any key differences that might need special attention the my Oracle 8 experience does not cover? Thank you.

    Guido770 pointsBadges:
  • RAC and parallel server

    What is difference between RAC and parallel server?

    667983690 pointsBadges:
  • remotely managing database securly

    If I want to work at one place and be able to manage the Oracle 8i database remotely and securly at another place, what should I do or set up? Thanks

    667983690 pointsBadges:
  • Duplicate records

    What is the best way to detect duplicate records within a large database where the primary key is different?

    Squirls0 pointsBadges:
  • Oracle database not starting on server reboot

    Would anyone know why an Oracle 8i database running on Windows 2000 will not automatically start on a server reboot?

    Oradba130 pointsBadges:
  • export RECORDLENGTH

    I was runing an export against an 8.1.6.3 database the other day, and got the following informational message: Note: RECORDLENGTH=1048576 truncated to 65535 I was wondering what the significance of this message is. The number 65536 happens to be the setting for SORT_AREA_SIZE. Thanks.

    Mljsher0 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