• Accessing Oracle from Mainframe

    One of our project is looking for information about accessing data in ORACLE from MAINFRAME applications (Z/OS). The data is lying on Oracle which is in a separate server and the IBM mainframe system (by using COBOL programs) need to access data from Oracle. I heard that Oracle has stopped its...

    saikumar8110 pointsBadges:
  • Converting Oracle Report to Excel

    How do I convert my Oracle D2K report to Excel?

    Sourabh99910 pointsBadges:
  • Common performance problems with Oracle Database

    What are some of the common operational problems with Oracle database?

    arahman1115 pointsBadges:
  • How do I update O.S. patches to Oracle DB RAC

    We have a 3 node Oracle Linux 7.3 UEK RAC DB Cluster. I need to know how to install Linux O.S. security patches (eg: kernel, OpenSSL, glibc etc...)

    gandalf210 pointsBadges:
  • How to avoid TAF in Oracle database

    I have one table, and indexes are created for all the columns still. I'm getting table access full for the same table, please tell me how to avoid TAF in Oracle database.

    Pankaj77215 pointsBadges:
  • Accessing Oracle database from mainframe COBOL program

    I have a mainframe Online COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I heard Oracle has...

    saikumar8110 pointsBadges:
  • Require an Oracle DB creation script without password prompt

    Hi, I require an Oracle DB creation script without password prompt. How can I do that?

    avidengle5 pointsBadges:
  • Query Oracle database as to contention between specific time

    Hi Guys. What is the best way to query an Oracle DB as to contention between a specific time; say 9:30-10:30 am. Any suggestion; including DBMS_STATS will be greatly appreciated.

    DomLock15 pointsBadges:
  • How to set Oracle database path with Oracle Developer

    How do I set an Oracle database path with Oracle Developer?

    Orcl5 pointsBadges:
  • Not able to run update statement to update Arabic name of customer in Oracle database

    My Oracle database is Arabic enabled. If I use application UI to change name to Arabic I can store it in DB and read it. When I run a update statement like update name1 = 'للسيدات فرع م' where account_number = '0000011234' . This statement is not updating required arabic details, it is...

    asimmund5 pointsBadges:
  • Data import on Oracle based system

    Hello, I work in the oil & gas industry and currently we work in an Oracle based system. I am new to this company and they currently don't have any established way to import data into the system (I know it is at least 9 years old); it has to be done in a very methodical, slow paced manual way...

    radavis985 pointsBadges:
  • Oracle database: Query for listing schema names

    In my Oracle database, I have to delete several unused schemas. Does anyone know if there's a way I can query for all my schema names so I can do this? Thanks very much.

    ITKE1,048,075 pointsBadges:
  • IN PL/SQL how to declare and use ‘STATIC DATA TYPE like C’

    Hi All, Can anybody help me to declare a variable having the similar propery of 'STATIC DATA TYPE IN C'. Means declare a variable and initialize it inside the procedure and called the procedure recursively but each time it is initializing the variable. I want any mechanism in PL/SQL that will make...

    Oracle10g4developers5 pointsBadges:
  • How to insert CSV file into Oracle database through PL/SQL procedure

    Hi all, I have a CSV file and I have to insert its data into the Oracle database. Is it possible through creating procedure if yes then give me any solution, I need it urgently. Thanks in advance.

    mollarubia5 pointsBadges:
  • 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:
  • Can I clone a user in the same Oracle database?

    I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

    ITKE1,048,075 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE1,048,075 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?

    ITKE1,048,075 pointsBadges:
  • Setting Oracle database to auto-commit

    Is there a way for me to find out if my Oracle database is set to auto-commit? If it is, how can I turn that off too? Thanks!

    ITKE1,048,075 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.

Following