• My Oracle server is corrupt, and can’t start using Oracle 8i

    Hi, We have a database that is running Oracle 8i on Windows 2000 server, but unfortunately it seems corrupt. our intention maybe would be to re-install the database on another machine and migrate all the applications. Please give us a guided approach to this problem, the database name DBCAB. Is it...

    Schinama15 pointsBadges:
  • How can I determine if a table exists in Oracle?

    I've been writing some different migration scripts for an Oracle database and I'm hoping Oracle has something similar to MySQL's "IF EXISTS" construct. Whenever I need to drop a table in MySQL, here's what I use: DROP TABLE IF EXISTS `table_name`; So if the table doesn't exist, the DROP doesn't...

    ITKE352,565 pointsBadges:
  • Database Migration code in MySQL

    Code to migrate database in MySQL (tables, triggers, stored procedures, functions and views) to Oracle, MS Access & vice versa.

    akashi5 pointsBadges:
  • ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name \

    I am getting this error in my system: ORA-00604: error occurred at recursive SQL level 1 ORA-01555: snapshot too old: rollback segment number 0 with name. How can I resolve this issue?

    chethanhb5 pointsBadges:
  • Oracle 11g R2 Forms and Reports error in configuration progress

    Dear all, While installing fusion middleware 11gR2 in Windows XP (32 bit) the process is hanging after completing step 14 of 15 (Configuration Progress) for more than 2 hours. Step creating domain failed. Configuration action 'Creating Domain' has failed. Kindly perusal my attachment file and give...

    Himac225238435 pointsBadges:
  • Oracle 10g terminated_with_error

    While I'm running an Oracle 10g report using the following code: declare   repid REPORT_OBJECT;   v_rep VARCHAR2(100);   rep_status VARCHAR2(50);  BEGIN   repid := FIND_REPORT_OBJECT('REPORT1');   SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms');...

    K197070 pointsBadges:
  • Error when using Microsoft OLE DB for Oracle in DTS Package

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • How to set oracle database path with oracle developer

    how to set oracle database path with oracle developer

    Orcl5 pointsBadges:
  • Report language change in Oracle Reports 6i

    I have a report in which report headings query is main query and report data query is sub query. I want to change the report language based on the language data available in the child query. Can anyone suggest to how to proceed?

    diliptiwari5 pointsBadges:
  • Win Drupal’s Building Blocks!

    Are you a developer? Today's free IT book is an essential addition to your library: Drupal's Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to...

    MelanieYarbrough6,345 pointsBadges:
  • Trying to install Oracle 10g

    I'm trying to install Oracle 1OG on an Acer 5520-5334 computer and it has been giving me a particular error 'No valid devices found, etc.) From my research, it seemed like the versions of Red Hat OS (RHEL 3.0,4.0) were not compatible with my computer. Please can anyone give me advice on what Red...

    DANIA5 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export

    My boss is getting an "EXP-00091: Exporting questionable statistics." error - actually, several identical messages per table - when using the EXP utility to dump several tables in an Oracle database.  I'm not familiar with this utility, so I'm researching the problem for my boss.  The...

    DeloeranGuy55 pointsBadges:
  • Error ORA-00904 on Export

    I am running an export command for backup purposes and receive the following error: Connected to: Oracle8i Release 8.1.5.0.5 - Production (5 user, NetWare Bundle) PL/SQL Release 8.1.5.0.5 - Production Export done in US7ASCII character set and US7ASCII NCHAR character set About to export the entire...

    Zimmerkidz0 pointsBadges:
  • Oracle 9i export unsuccessful since patch update.

    Hi, i'm quite new to oracle, i've got an oracle 9i database been running 1 year, which runs an export every night. Everything has been working fine on 9.2.0.1.0. I updated straight to 9.2.0.7.0. Everything else looks ok. Users, still happy. Now export fails with: Connected to: Oracle9i Release...

    aglking0 pointsBadges:
  • How to insert/delete/update data into VIEW using forms 6i

    i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?

    Mohan24835 pointsBadges:
  • row_number in SQL 2000

    How do I find out the row_number in SQL 2000 like using row_number() function in SQL 2005?

    Rl10 pointsBadges:
  • Oracle 10g – WEB.SHOW_DOCUMENT parameters

    What other parameters can be used with WEB.SHOW_DOCUMENT besides '_BLANK'?

    jkeri360 pointsBadges:
  • Problems calling report using WEB.SHOW_DOCUMENT

    I am using Oracle Report and Forms 10G and trying to call a report from Forms using the following code: DECLARE rep_url VARCHAR2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=C:Oracle DbDEPARTMENT_EMPLOYEES.jsp' ||'&desformat=htmlcss&destype=cache'...

    Crix5 pointsBadges:
  • A problem in calling Oracle report by using WEB.Show_Document

    - The application is developed in Developer 10g - The application is` running with non ssomode. (ssomode=false) - When I call a report through form by using: WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||...

    K197070 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