• Tablespace recovery

    Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if...

    Mayleong0 pointsBadges:
  • Email alerts and export report to Excel

    I'm running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily basis. This is...

    Mayleong0 pointsBadges:
  • Naming Constraints and Moving Tables

    Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to "clean-up" his act 1)Move all my uses even SYS...

    Mayleong0 pointsBadges:
  • Oracle ./runInstaller problem

    Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

    Asiankiwi0 pointsBadges:
  • Oracle 9i Instance and database creation from the command line in WIN NT 2000

    Hi, Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)? I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba". When I specify a...

    Sumeshs0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • SYS account problems with 9i

    Hi, When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error. Surprisingly, I can log in as SYSTEM and another DBA account. The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not...

    Sumeshs0 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:
  • Unix ODBC Drivers

    I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on Unix...

    Jk666380 pointsBadges:
  • Oracle Application Remote Administration

    Hello Sir/Madam/Mrs/Ms, i'm not sure whether is this the right platform asking my type of questions, but just go ahead. I have an Oracle database server and application server at Premise A. Right now i'm in Premise B which is geographically apart from Premise A about 365km. I want to access Oracle...

    Mofazha0 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:
  • switching between instances without down time

    I am installing a new warehouse. I will be running two instances on the same physical server. I plan to load data into one instance while the other is being used for reporting. At the completion of the load process, I need to point the new user connections to the just loaded instance and allow the...

    Lfelder0 pointsBadges:
  • Upgrading Oracle on Windows 2000

    I am preparing an Oracle upgrade from 8.1.7.4 to 9.2.0.5 on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, and let it...

    Mljsher0 pointsBadges:
  • Oracle 9.2.0.4 and gcc compiler

    We just upgraded to Oracle 9.2.0.4. When we try to compile a program, we get the following error: ld: fatal: file /u100/app/oracle/product/9.2.0/lib//libclntsh.so: wrong ELF class: ELFCLASS64 error when trying to compile with GCC version 2.95.3. I was wondering if anyone had run across this, and,...

    Mljsher0 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:
  • Data Guard Implementation

    Does anyone have any experience and/or issues with implementing a logical standby database for disaster recovery? We have enough disk for 1 standby database and the users want to query it as well as have it for disaster recovery.

    PeppermintP0 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:
  • Passing array as output parameter through procdure/function

    Any suggestions on implementing a procedure that passes an array as output parameter and using this as an input to a second procedure and manipulating it?

    PRASAD550 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:

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