• 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:
  • Oracle connectivity

    Recently We installed Oracle 8i ( Server on a Machine running Windows 2000 Professional SP 4, but we're experiencing connectivity problems: 1 minute after the Listener started up it's not possible to connect to the database any more . At this point, if the listener service is restarted then...

    carlosdl84,450 pointsBadges:
  • Error when tried to update the SSOledbGrid connected to with Sybase Server Database

    I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update...

    Icaro20 pointsBadges:
  • Database Administration

    Hi i am working with Ministry of communication & IT (INDIA).My question is i hav install oracle 9i at my home.When i go to command prompt & tries to connect it with sysdba, it is not able to connect....its says following error...(tns:unable to find host or service name).i have connectin it with...

    Technomeinung0 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:
  • Identifying all SQL generated by a specific session

    I am trying to isolate all SQL generated by a specific user in a specific session. Short of using auditing can I tie specific session parameters like sid, serial#, username to SQL still available in the shared SQL area?

    Jrmills0 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:
  • Database groups in Ireland

    Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?

    Pegasusdba0 pointsBadges:
  • ORA-01436 error

    We are trying to use connect by ..prior feature of oracle. Having said that we had used this type of queries and now we are facing this loop error for connect by prior. Any suggestions.

    PRASAD550 pointsBadges:
  • RAC and parallel server

    What is difference between RAC and parallel server?

    667983690 pointsBadges:
  • Peoplesoft DBA

    I may have an opportunity for a Peoplesoft DBA job. I've done a wide gamut of Oracle DBA work at a major university for the last 10 years and am looking for a challenge. I don't know what skills this kind of position would require or allow one to develop. This is my main concern. Would it provide...

    Jrmills0 pointsBadges:
  • Adding column to an exiting primary key

    We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.

    PRASAD550 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:
  • Using Record Type

    We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk collect...

    PRASAD550 pointsBadges:
  • Duplicate records

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

    Squirls0 pointsBadges:
  • DISTINCT or work-around

    Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query 1 ===================== Operation...

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