• 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?

    ITKE413,575 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!

    ITKE413,575 pointsBadges:
  • Cannot connect to Oracle database: Oranos.dll is missing from my computer

    I've been trying to connect to my Oracle database but when this code is running (con = new OracleConnection(oradb);), it keeps giving me this error message: The program can't start because oraons.dll is missing from your computer. Try reinstalling the program to fix this problem. What should I do?...

    ITKE413,575 pointsBadges:
  • Deleting millions of records in Oracle database

    My Oracle database has roughly 2 billion (yes, I said billion) records. But we noticed that over 10 million of them are duplicates. How can we go about deleting those? Thanks!

    ITKE413,575 pointsBadges:
  • Getting all sequences in Oracle database

    Hi experts! Would there be an Oracle command I could run so I could get all of the sequences in my Oracle database? This is for Oracle 11g / Oracle Toad. Should I use the command line?

    ITKE413,575 pointsBadges:
  • Manual uninstall of Oracle

    For some reason (this only happens once in a while) but my Oracle database on Windows disappears. Because of this - I'm thinking of doing a manual uninstall. How can I do that?

    ITKE413,575 pointsBadges:
  • Insert table into existing Oracle column

    I noticed that whenever I try to add an existing to an existing column in Oracle, it's always down at the end of the table. Is there an Oracle command where I can tell it to put it in the table? Thank you.

    ITKE413,575 pointsBadges:
  • I would like to take a backup of Oracle Database by using unix scripts

    I would like to take a backup of Oracle Database by using Unix scripts. Is it possible? If yes, please provide the details.

    shamcpt5 pointsBadges:
  • Oracle Certification?

    Hi, I want to know, the total procedure for Oracle data base certification. Thanks

    Amin4rmOvexTechnology250 pointsBadges:
  • Connect remote Oracle database through PL/SQL Developer

    We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

    ITKE413,575 pointsBadges:
  • Finding size of Oracle database

    We have a database in Oracle that we need to figure out the exact size of (it's currently on our disk). How can we do that? Is there a certain Oracle command? Thanks!

    ITKE413,575 pointsBadges:
  • Display all views in Oracle database

    On an Oracle database, can I display all the views that are currently set? Can I do this through SQL Developer?

    ITKE413,575 pointsBadges:
  • Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE413,575 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...

    ITKE413,575 pointsBadges:
  • Oracle Database 12C on Ubuntu

    Does anyone know how I can install Oracle Database 12c on Ubuntu? I tried but I keep getting errors during the linking phase. Thanks for any help.

    ITKE413,575 pointsBadges:
  • Name of server my Oracle database is hosted on

    I'm in desperate need here for some help: How can I find the name of the actually server my Oracle database is hosted on? Thank you so much!!

    ITKE413,575 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE413,575 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...

    ITKE413,575 pointsBadges:
  • Can an Oracle database work with Microsoft Entity Framework?

    Apologizes for the short question (I don't have enough information) but I'm working with Oracle database. Can I have it work with Microsoft Entity Framework? If so, what's the process I have to go through?

    ITKE413,575 pointsBadges:
  • Oracle: See list of databases

    In Oracle, is there a way I can see a list of my databases? Something like MySQL's SHOW DATABASE statement? I need to find the databases in a cluster too. Thank you.

    ITKE413,575 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