Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • Oracle error ORA-01034 and ORA-27101

    I tired to connect but I'm not able to connect. I'm getting the following error: ORA-01034 - Oracle not available / ORA 27101 - shared memory realm. This is in Windows 7 with version Oracle 11g. I have started it up and mounted it but still not useful for me.

    HEMANT20165 pointsBadges:
  • Rename the Oracle 10g database user

    Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

    S1989082060 pointsBadges:
  • How to create multiple Oracle 11g databases

    Our department is currently using Oracle 11g and all of us are using it (including developers). But here's the issue - we can't buy several different licenses for each person. Would I be able to create one specific data for each person?

    ITKE434,585 pointsBadges:
  • How to uninstall OracleserviceXE

    I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message "OracleServiceXE is present on the system". How can I fix this please? Des

    Desjacks5 pointsBadges:
  • How to run oracle 10g forms without browser !!

    I'm working on application using oracle 10g forms .. im done with it .. but i wanna run my application .. without the need to run browser with it . Is it possible ??? Please let me know and help me with it .

    Ahmedshahbo15 pointsBadges:
  • VB6 with Oracle 10g as database: Using add, edit, delete and search button with following fields: title, author, publisher, year, category

    How can I set up a library system with add, edit delete, search button  with following fields: title, author, publisher, year, category using VB6 and Oracle as database? Thanks

    jeremy275 pointsBadges:
  • Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE434,585 pointsBadges:
  • 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.

    ITKE434,585 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...

    ITKE434,585 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:
  • Running Oracle 10g form

    I can't get a form to run through the browser on my machine. I can compile ok, but when I run the form I get the "cant display page" error in IE. I have the listener running. What am I missing?

    Tdmcolumbus75 pointsBadges:
  • How to run Oracle 10g forms on browser

    Hello everyone, When I run form browser, it shows only Oracle forms. Please help me solve my problem.

    Scarletsys5 pointsBadges:
  • How to retrieve last record from given table without using rows function in Oracle

    I don't use rows function like row_num, rowid, rownumber. How can I do this in Oracle?

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

    ITKE434,585 pointsBadges:
  • Oracle 10g: Rename table column

    Hi experts! Does anyone happen to know how I can rename my table column in Oracle? Particularly Oracle 10g? Thanks so much.

    ITKE434,585 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...

    ITKE434,585 pointsBadges:
  • username and password is asking oracle 10g database

    i installed oracle 10g dba clint side in my pc, but username, password and string is asking pls help me sir/madam

    Unix5 pointsBadges:
  • Insert data into newly created Oracle 10g tables

    I have created a database for scenario. I have 6 tables created. I am having difficulty inserting the data.

    Ray30syed5 pointsBadges:
  • Error message when starting up Oracle 11g database on Windows Server 2008 R2

    I'm running Windows Server 2008 R2 and when I'm trying to startup Oracle 11g database, I keep getting this error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2180024 bytes Variable Size 1996491848 bytes Database Buffers 1191182336 bytes Redo Buffers...

    ITKE434,585 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:

Browse Alphabetically:

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.

Following