• Install Oracle 11g R2 on Ubuntu

    Does anyone know how I can install Oracle 11g R2 on Ubuntu? I'm currently using a 32-bit operating system but this would be for a x86 version. Desktop is 64-bit too. Thanks for the help.

    ITKE407,310 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE407,310 pointsBadges:
  • RAC patching: How to force sessions to connect to other node

    Hi experts, I have one query regarding applying a patch (interim,psu) in a 4 node RAC in rolling fashion. My question is while applying patch on one node I heard that we should down the instance and we will apply remaining nodes are up and running. At that time what happens about the running...

    sirajdba175 pointsBadges:
  • Cannot download Oracle Express 11g

    I'm trying to download Oracle Express 11g but it keeps offering me only downloads for for Windows 32-bit and Linux 64-bit. Can I get it for Windows 64-bit? Thanks so much.

    ITKE407,310 pointsBadges:
  • Searching Oracle 11g database for string in tables

    I'm trying to search my Oracle 11g database for a string in all of my columns and tables. Here's the query I'm using: BEGIN FOR t IN (SELECT table_name, column_name FROM all_tables) LOOP EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||t.table_name||' WHERE '||t.column_name||' = :1' INTO match_count...

    ITKE407,310 pointsBadges:
  • If I search with and FK ID_Entity on a big table, takes 0.05s to return 2000 rows, but if I search with the FK and a Varchar2(1) takes too long!

    I have a table with 3000000 rows. With a Select count(1) from  Conceptos where id_entidad = 1 Takes 0.05s to return the number 2000 But if I search Select count(1) from  Conceptos where id_entidad = 1 and Esta_Aprobado = 'S' Then it takes 7s to return the same number I hace index over Id Entidad...

    romaedu2005 pointsBadges:
  • How to insert looping data in Oracle database using VB.NET?

    Dim cmd = New OracleCommand For i = 0 To DataGridView1.Rows.Count - 1 Sql = "INSERT INTO TM_EMPLOYEE_INFO (V_EMPLOYEE_NO, " Sql = Sql & "V_NAME_TRAINEE,N_GENDER,V_COMPANY) " Sql = Sql & " VALUES('" & DataGridView1.Rows(i).Cells(0).Value & "', " Sql = Sql & "'" &...

    ajpascual195 pointsBadges:
  • Oracle 11g on Google Chrome

    We had developed application on using Oracle Forms and Reports 11G with backend Oracle Database Standard Edition Release 11.1.0.6.0. Both are installed at windows 2008 server. It was purchased from Premier System Limited. When the developed application was deployed and run on Internet Explorer, it...

    ghauria15 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:
  • Oracle 11g KEEP buffer pool

    What is the SQL to determine what table objects are in the KEEP buffer pool?

    jmarsh5 pointsBadges:
  • Oracle 11G database installation error

    I am new to Oracle database. While trying to install the database software, I get: DIM-00019: create service error ORA-12560: TNS:protocol adapter error I have been trying for a long time to install the database but cannot. How do I install the database?

    prashantmishra29015 pointsBadges:
  • AUTO_INCREMENT in Oracle 11g

    I might have missed something but, in Oracle, is there no concept of AUTO_INCREMENT? If there isn't, is there a way to create a column that resembles AUTO_INCREMENT in Oracle 11g?

    ITKE407,310 pointsBadges:
  • To show two columns using select syntax in Oracle 11g referring another column in same table

    Hi everyone, I really need help on one thing. Suppose I have a table employee and there are many columns and three of them are empno, ename and managerno(of employees) and o want to show results using select syntax and the managerno contains the empno of employees and I want to show ename and (a...

    Pranay9988775 pointsBadges:
  • Import dump file in Oracle 11g

    When I'm importing dump file in Oracle 11g then it raises one error, "IMP-00013: only a DBA can import a file exported by another DBA IMP-00000: Import terminated unsuccessfully." "

    siva12315 pointsBadges:
  • Oracle report 6i preview problem

    Oracle 11g & report 6i can't preview. Can anybody can help me?

    sojeeb5 pointsBadges:
  • Oracle 8i to 11g Upgrade

    I want to upgrade Oracle 8i to 11g on Solaris 10. What will be the best way to do it? I really appreciate your help.

    Ashkanvir15 pointsBadges:
  • Error when running any program in Oracle JDeveloper 11g

    Error occurred during initialization of VM Could not reserve enough space for object heap. Kindly give me an idea to solve this problem. Thanks in advance.

    69598410 pointsBadges:
  • Locate J2SE PLUS SDK downloads

    I have been out of the job market for about six years. I am attempting to upgrade to 11i and earn certification. I have downloaded and installed 11g V2. When I try to bring up the SQL Developer I get a message to provide a path to jave.exe. When I do that, I receive a message that it cannot find...

    JoeBear10 pointsBadges:
  • How to migrate Oracle 10g forms in Oracle 11g

    How do I migrate Oracle 10g forms in Oracle 11g?

    Sanjaygehija5 pointsBadges:
  • Increase performance of SQL loader

    Like to hear best practices to be followed to increase performance of SQL loader.

    Mraman260 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