• Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Converting and deploying 6i Forms to Forms 10g

    I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot,...

    Herbiebill35 pointsBadges:
  • Problem with ORA-01034 and ORA-271017

    I am running Oracle 11 on Linux Ubuntu 12.10. The database has been running well for a long time. Now, suddenly, when I or one of my applications tries to connect to the database, the database replies with ORA-01034 and ORA-27101.  I've tried most of the available suggestions, and either they...

    tcnmann20 pointsBadges:
  • ORA-01009: Missing mandatory parameter

    Dear Friends I have this script in the WHEN-BUTTON-PRESSED Button DECLARE LOC_FLAG NUMBER; BEGIN :IM_NEW_ITEMS.COLOR_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.COLOR_CODE,0)); :IM_NEW_ITEMS.SHAPE_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.SHAPE_CODE,0)); SELECT NVL(FIN_FLAG,0) INTO LOC_FLAG FROM IM_CLASS WHERE...

    MAY05659292714145 pointsBadges:
  • Convert single instance database to Oracle RAC on ASM

    Hi, I have single instance database without ASM. Now I want to convert this database to Oracle RAC database using ASM. Please mention the steps to convert this database to RAC. I have version 11gR2 (11.2.0.4). Regards Nadir Pervez Gill

    NadirPervez5 pointsBadges:
  • how to open oracle in web browser??

    how to open oracle 10g using web brouser?? nd what is the maximum memory for oracle ?? wht should be it's IP ADDRESS??

    Aamir000860 pointsBadges:
  • How to run Oracle 10g form on Netscape

    How to run Oracle 1og form on Netscape 7.2. It gives me plugin issue.

    musakaleem5 pointsBadges:
  • Output (.LIS FILE) of SQR report

    How to hide the man like symbol at the end of the page of the SQR report? Thanks in advance!

    priyavijayakumar5 pointsBadges:
  • Is It possible to retrieve dropped tables in Oracle?

    Hello Experts, I want to know one thing that is it possible to retrieve the dropped tables by mistake from an application user? If yes then please share the procedure involved it so that I can proceed further accordingly.

    VijayDahiya125 pointsBadges:
  • Delete command is not deleting the form records in details block

    DECLARE LOC_ITEM_CODE VARCHAR2(30); LOC_ITEM_CLASS VARCHAR2(10); LOC_ITEM_TYPE VARCHAR2(10); LOC_ORDER_CODE VARCHAR2(10); LOC_ITEM_LENGTH NUMBER(10,2); LOC_ITEM_WIDTH NUMBER(10,2); LOC_ITEM_HIGHT1 NUMBER(10,2); LOC_REQUEST_YEAR NUMBER(4); LOC_REQUEST_NO VARCHAR2(25); LOC_BIG NUMBER(12,3); LOC_SMALL...

    MAY05659292714145 pointsBadges:
  • Connect database from Oracle to VB 6.0 in SQL Server

    I'm a BCA student. I'm doing my project on college management system with VB 6.0. I want to know how to connect a database from Oracle to VB 6.0 in a SQL Server. Thanks!

    eliza72472fathima5 pointsBadges:
  • Cache Oracle tables in a NetApp cache

    Sysadmins say our Oracle databases are using virtually none of the 512GB NetApp cache. Is there a way to cache Oracle tables in the NetApp cache similar to the Oracle keep pool?

    royaldbaness5 pointsBadges:
  • UPSERT in Oracle table

    Is there a way to UPSERT in Oracle (so I can insert either / or update a row into a table? I thought Oracle doesn't have that statement so I'm not sure the best way to do it. Thank you.

    ITKE407,235 pointsBadges:
  • Current Example does not handle duplicate Value 1 population

    IF we take the same example and Ray has a 2 rows where Value 1 is populated. Max will return only 1 row.....how do you collapese the rows so that both values retained for Ray and perhaps take it further align the similar values. Asuming that all of these rows belong to 1 FK

    sabinasql5 pointsBadges:
  • Make copy of an Oracle table without the data

    Anyone know how to make a copy of an Oracle table without actually copying the data? I figured out this statement: create table xyz_new as select * from xyz; But that only copies the structure / data. I just want the structure. Thanks!

    ITKE407,235 pointsBadges:
  • SAP Crystal Report 2013’s compatibility with Oracle 8i

    Is Oracle 8i still capable with the new versions of Crystal Report (E.G: 2013?)

    BillYuAtbcs5 pointsBadges:
  • How can I become a DBA?

    I'm in a 2nd year CS engineering student and want to be a DBA. How shall I proceed?

    HritikaMehta5 pointsBadges:
  • Oracle 11G database installation error

    I am new to Oracle database. While trying to install the database software, I get: DIM-00019: create service error ORA-12560: TNS:protocol adapter error I have been trying for a long time to install the database but cannot. How do I install the database?

    prashantmishra29015 pointsBadges:
  • AUTO_INCREMENT in Oracle 11g

    I might have missed something but, in Oracle, is there no concept of AUTO_INCREMENT? If there isn't, is there a way to create a column that resembles AUTO_INCREMENT in Oracle 11g?

    ITKE407,235 pointsBadges:
  • How to use POS.NET for a BARCODE SCANNER in a VB.NET application

    Hi! I have an old office project... Its Point of sale software built in VB.net over oracle db express edition. Its really cool but lucks the barcode scanner functionality. Some customers are demading for that functionality.....bla bla bla!!!  ...Devices I've programmed 4 in the past usually comes...

    49cubes45 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