• ORA-03127: no new operations allowed until the active operation ends

    Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can...

    Costaf40 pointsBadges:
  • Oracle Forms application behave as a web portal in a browser

    I am migrating an Oracle Forms 6i application to Forms 11g and I need it to: Scale as any web application with the browser Get the WMI title visible Expand to all the browser window Thanks in advance. Javier

    JavierG5 pointsBadges:
  • Oracle sub query

    I need to display the names of male and female programmers. I have name as a field in the programmer table and now depending on the sex I have to display the names separately. Can you help me out with the query?

    udayasri5 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:
  • Copying from host machine to database Server directory

    I want to copy a file from my host machine (in this case the Windows 10 machine from the user) to a directory located in the database server (Linux) with a Oracle 10 forms. How can I do that?

    ricgomsa25 pointsBadges:
  • License the entire Oracle server, if we use IBM LPAR (uncapped) for hard partitioning?

    Do we have to license the entire Oracle server, if we use IBM LPAR (uncapped) for hard partitioning?

    himanshu115 pointsBadges:
  • Why do we need Cassandra?

    Why do we need Cassandra if we have the Oracle data sets and what is advantage over Oracle?

    bbsdssd5 pointsBadges:
  • How I can do a row ID in SQL Server

    Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.

    LuisFer5 pointsBadges:
  • Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

    When I'm compiling a package, I'm getting below error. Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure. I'm using is Oracle 11g in SQL Developer.

    Vimalkv15 pointsBadges:
  • Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:
  • Oracle reports

    What is the method of run\call report on form in Oracle Developer 10g?

    Rat15 pointsBadges:
  • ORA-01002: fetch out of sequence

    We have a procedure in production working but in testing, both are failing: create or replace PROCEDURE Crown_spu (p_nbrec IN NUMBER, p_recordset OUT Crown_Types.Crown_cursor) AS w_batchid VARCHAR2(20); w_nbrec NUMBER := 0; w_seq NUMBER := 0; CURSOR c_feedback IS SELECT Eventid_0, Eventkey_0,...

    MikeBerry15 pointsBadges:
  • Oracle: Count on only one table within select

    I have the following SQL and want to add to the query a count of records for each of the tables selected out of the user_tables, basically count(*). I've tried several things, but am getting only a count of 1. Any help would be appreciated. select substr(a.table_name,1,15) , substr(b.t$desc,1,40) 2...

    nemsmith30 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 pointsBadges:
  • Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • Tune the Oracle query

    SELECT a.custno, a.stockto, a.dayname, TO_CHAR (a.rad, 'IYYY') || TO_CHAR (a.rad, 'IW') "WEEKNO", a.rad, -- COUNT (NVL (a.load_number_last, a.cono)) "TDY_LOAD_CNT", SUM (a.load_count) "TDY_LOAD_CNT", NVL (TO_NUMBER (b.avail), 0) "TDY_CAP", DECODE (TRUNC (a.rad), TRUNC (SYSDATE),...

    delphi1235 pointsBadges:
  • I forgotten my user name and password of Oracle 10g express edition.

    I'm using oracle 10g express edition, I forgotten my username and password so please suggest me any idea to recover the username and password or tell me any other possibilities to reset the username and password.

    Sreekannan5 pointsBadges:
  • Oracle FK Dependencies

    A query I run accesses multiple tables. One of those tables has a FK dependency on a column, which is populated by the application and hardcoded as a single value for all records. So in the where clause when im joining all the tables to get the data required, it is only pulling data for that...

    Rishik015 pointsBadges:
  • Large NQS_*.TMP files

    Hello,I am BI Developer/Consultant and i am currently cluless on the issues with large NQS_*.TMP files in OBIEE. I am currently on obiee - 11g - I see that after selecting a dashboard report, a NQS_*.TMP file is created in...

    moehashim5 pointsBadges:
  • Cannot reinstall Oracle 10g

    When I successfully removed Oracle 10g from CMD, I tried to install again but it takes a lot time to install and a page. Showing creating and starting database services appears for a long time with same progress bar. It doesn't increase at all? It seems to be paused.

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