All Tags » 11g (RSS)

Browse by Tags

  • ORA-04031 when creating a new 11g instance

    I am trying to create a new instance on a fresh install of Oracle 11.1.0.6 and encountering the following error during the jserver.sql portion of the create script. Once the error occurs, sqlplus exits and the database creation fails. How can I fix this issue? Do I need to increase the size of any of...
    Posted to 11.x (Forum) by software on 05-12-2010
  • Help me I need to start learning Oracle.

    Hi I got a new job they have Oracle 11g and they have no training at all. Tthey want me to teach my self Oracle 11g. I do not know how to start and there are different books and courses Please help me what to do I must know all about Oracl 11g but I can't afford taking a course. I never done any...
    Posted to Oracle (Forum) by software on 03-10-2010
  • Developing with Oracle .Net ODAC/ODP 11g with a remote Oracle 10g XE Database

    Hello Experts I am a young C# Developer and I am familiar with the System.Data.SqlClient/System.Data.OracleClient namespaces however I recently found out that Oracle is no longer supporting this driver. I have been given the task of building a c# web service on Visual Studio 2008/.Net Framework 3.5 which...
    Posted to 11.x (Forum) by software on 11-13-2009
  • When will there be an Oracle 11g Express Edition?

    As the title states. Can someone tell me if there is a planned release for Oracle 11g Express Edition? I can't seem to find anything about the site.
    Posted to 11.x (Forum) by software on 09-26-2009
  • Defragment SAN disks -- Good or bad?

    OS: RH Linux X86_64 DB: 11.1.0.7 Storage: SAN w/64k page size. What does Oracle recommend as far as running disk defragmentation utilities on the database mount points? Our SA set this up and has been running it for a little over a week -- and we suspect it is causing some issues. Thanks for any white...
    Posted to 11.x (Forum) by software on 09-11-2009
  • Oracle XML DB vs Relational DB

    Hello, I am interested in understanding the pros and cons of storing billions of rows for real-time access in XML DB or in a traditional relational DB. The logical data model for this solution has two dozen or so relations, each not more than a dozen of so columns wide, however, some are very long. The...
    Posted to 11.x (Forum) by software on 09-04-2009
  • Get the Primary Key Given the table name

    I have to reterive the primary key given the table name as input. The following query takes about 3 seconds to execute and its costly for me as its executed in loop. SELECT COLUMN_NAME FROM USER_CONS_COLUMNS UCC, USER_CONSTRAINTS UC WHERE UC.CONSTRAINT_NAME= UCC.CONSTRAINT_NAME AND UC.OWNER= UCC.OWNER...
    Posted to Oracle (Forum) by software on 08-17-2009
  • 1Z0-047 vs. 1Z0-051 vs. 1Z0-007 - Which One is Good?

    1Z0-007 and 1Z0-051 exam topics are easier than 1Z0-047. However, 1Z0-051 is a new one Oracle Database 11g: SQL Fundamentals I. Source: http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=155 Any help will be appreciated
    Posted to 11.x (Forum) by software on 08-16-2009
  • Windows OS Oracle Account Considerations

    Hello, Up to this point all our Oracle Windows 2003 servers have used a local system account where they also are a member of the local administrators group. We are using Oracle 10g (10.2.0.4). Essentially we want to create a domain service account to run services locally on the server. Add it to a group...
    Posted to Oracle (Forum) by software on 07-08-2009
  • flash_recovery_area full-- how do you use RMAN to delete directories of .arc files

    About a week ago we turned archivelog mode on in an 11g oracle server. The flash_recovery_area is now full, and redo logs can't be archived, so the database won't open. I need to delete some of the dated directories containing the .arc files using rman. What is the exact process for connecting...
    Posted to Oracle (Forum) by software on 07-04-2009
Page 1 of 4 (36 items) 1 2 3 4 Next >