• 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,005,485 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,005,485 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,005,485 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,005,485 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,005,485 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?...

    ITKE1,005,485 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!

    ITKE1,005,485 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?

    ITKE1,005,485 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?

    ITKE1,005,485 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.

    ITKE1,005,485 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:

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