• How can I create a user in Oracle 11g?

    I need some help! I'm trying to create a user in Oracle 11g and only grant them the ability to execute one stored procedure, along with the tables in the procedure. Is that possible? If so, what's the process to do it?

    ITKE347,785 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE347,785 pointsBadges:
  • How to turn off password expiration permanently in Oracle 11g

    I've been using Oracle for my development testing. But now the password for my bootstrap account that I always use to rebuild my database has expired. Is there a way to turn off the password expiration for users permanently? I'm currently using Oracle 11g. Thanks so much.

    ITKE347,785 pointsBadges:
  • DBMS_CRYPTO package to encrypt & decrypt in Oracle 11g

    ORA-06521: PL/SQL: Error mapping function > >ORA-06512: at "SYSTEM.DBMS_CRYPTO_FFI", line 3 > >ORA-06512: at "SYSTEM.DBMS_CRYPTO", line 13 > >ORA-06512: at "SYSTEM.ENC_DEC", line 21

    Mohanasundharam5 pointsBadges:
  • Benefits of Oracle database 10g vs. 11g editions?

    What are the benefits of Oracle 11 g edition over Oracle 10 g express edition?

    MUKUNDSAWANT55 pointsBadges:
  • How can I install Oracle 11g client?

    I've been trying to install Oracle 11g (client) but I keep getting this error: Environment variable: "PATH" - This test checks whether the length of the environment variable "PATH" does not exceed the recommended length. Expected Value: 1023 Actual Value : 1028 List of errors: - PRVF-3929 : Adding...

    ITKE347,785 pointsBadges:
  • Receiving ORA-01033 error message on Oracle 11g

    I recently installed Oracle 11g on Windows 7 and everything has been working great. But now I keep getting this error message: ORA-01033: ORACLE initialization or shutdown in progress. I've tried to figure it out but I'm still getting the error. I tried connecting as "SQLplus sys/sys as sysdba" but...

    ITKE347,785 pointsBadges:
  • Can I use an Oracle 11g client on a Oracle 10g server?

    For the past few months, I've recently created a .NET program that uses ODP.NET, specifically with Oracle 11g. But our Oracle server has been running 10g and I can't make a change. Can I run an Oracle 11g client on a 10g server? Or am I in big trouble?

    ITKE347,785 pointsBadges:
  • What’s the difference between Oracle 9i, 10g, 11g?

    And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only.

    Pooni20 pointsBadges:
  • Cannot create Oracle 11g database

    SQL> @createdb.sql create database sam * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 5 ORA-00604: error occurred at recursive SQL level 1 ORA-30012:...

    sumeetmalani29180 pointsBadges:
  • Event ID 34 Application Event log message

    Application freezing up for users. Informational message in application event log: The description for Event ID ( 34 ) in Source ( Oracle.xxxx ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You...

    Cathyhaskins384115 pointsBadges:
  • How to uninstall Oracle 11g

    I am a beginner with oracle I just installed it, but after 1 day it's SQL plus window starts showing an error "an initialization or shutdown in progress" I already ran some commands like "database pluggable all open" and "instant startup or shutdown", shown on your site yet not working, so I wanted...

    sameeksha5 pointsBadges:
  • Error using SAP Crystal Reports

    When I deploy my ASP.NET website on Windows 7 with Oracle 11g database in back end. I am using SAP Crystal Report version 13.0.2000.0 It gives error as: Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred...

    Ashutoshpatilak10 pointsBadges:
  • How to connect Visual Basic 6 to Oracle 11g

    What are the steps to connect VB 6.0 to Oracle11g? Thanks!

    Rupeshit5 pointsBadges:
  • Execution of Oracle 11g wrapped procedure gives ora-00900 error

    Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it...

    askmsc15 pointsBadges:
  • How to sort a resultset from a ‘group by’ statement

    I have written a query like this: select to_char(order_date,'mon-yyyy') "months", sum(nob) "number of bags" from p_in where order_date between '1-apr-11 and '31-mar-12' group by to_char(order_date,'mon-yyyy') The above query returns me a resultset which gives me number of bags sold in every month,...

    hussain22juzer500 pointsBadges:
  • Problem connecting D2K 6i with database Oracle 11g

    Steps to connect D2K 6i, with oracle database 11g.

    v15 pointsBadges:
  • Can anyone tell me what is the difference between oracle 10g and oracle 11g in way of comparison

    Please, can anyone tell me what is the difference between Oracle 10g and Oracle 11g in way of comparison?

    161220 pointsBadges:
  • oracle 11g oam console login on Win 2008

    Has anyone been able to install OAM 11.1.1.5 on Win 2008 R2 and able to log in to the oamconsole?

    Sparky850045 pointsBadges:
  • Query from Oracle forms to Excel sheet

    I had a matrix report made in oracle reports builder 11g. This report was called from a button in my form. now, I want to open an excel file when that button is pressed and show the data exactly in the format as it was shown previously in the report which was made using report builder. I am unable...

    Sarah1234520 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