• 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:
  • How to update a oracle table containing 4 billion records

    I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is...

    Ws8oBPSQ15 pointsBadges:
  • How can I update a huge Oracle table containing 4 billion records

    I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace...

    Ws8oBPSQ15 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • 10G Database Restore to New Server from Backup

    I am a Sr. SQL Server DBA but brand new to Oracle. I have been given a task by my management to perform a backup from our production server and restore it on a brand new server to simulate a disaster. Our environment is Windows 2003 Server and Oracle 10g database. I am having allot of difficulty...

    Sqldatapro0 pointsBadges:
  • Configuring isql *plus

    Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Difference between length and vsize functions

    Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • DATABASE RECOVERY , WINDOWS 2000 , ORACLE 10G

    Hi Brian, I am a student at West Virgibia University, and manage a database with tables. My problem is that my system has crashed, I can get it up and running but on a different partition, so that my files are intact on the original partition, but my database wont run, because it was installed on...

    Deepakjha0 pointsBadges:
  • Erros starting SQLPLUS after a no problems installation (oracle)

    I'm running Fedora Core 3 In my terminal I $ sqlplus and I'm prompted for my username and password. No matter what I type in, I get these error messages ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist It makes me think I've got my uname and password wrong but I don't -...

    Keithcybin0 pointsBadges:
  • 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:
  • error on instaling grid on XP

    i have a oracle database 10g in windows XP, but when i try to install the grid control always give me this error: invalid version: to be used for management repository, the database must be version9.2.0.4.0, version 10.1.03.0, or a patch release for one of those versions.

    Fbecerra0 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:
  • RAC and parallel server

    What is difference between RAC and parallel server?

    667983690 pointsBadges:
  • Oracle 10g ASM

    Can you create ASM instance without creating a database? If yes, how?

    Mwhpsrc0 pointsBadges:
  • upgrade to 10g

    Looking for some input about upgrading/migrating to 10g from 8i databases. I have successfully migrated to 9i from 8i and even 7 version databases, but have not had the opportunity to work with 10g. Thank you, tuple9i

    Tuple9i0 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