• Oracle 8i to Oracle 10g Export /Import

    Hi, Presently iam Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so i want to ask you that it...

    134915 pointsBadges:
  • PL/SQL performance tuning…

    I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the...

    Jelewis0 pointsBadges:
  • How to capture emails with attachments from the POP server using Pl/SQL ?

    I am able to retrieve emails from POP server using UTL-TCP package of PL/SQL. I am also able to retrieve Attachment with the email, but the contents of the Attachment are displayed as some random string of characters. Can anyone tell me how can I access the contents of the Attachment in...

    Monk10 pointsBadges:
  • good PL/SQL user guide

    I am interested in a good reference guild for PL/SQL which explain all utilitity commands and configuration patterns and files. Your help is much appreciated.

    Hfeshari0 pointsBadges:
  • BW load performance

    BW data load performance using Oracle 10g and windows 2003 env. how to improve CPU, DB, dialog response time? any notes for Oracle patches, SAP any notes?

    RAVPATHI5 pointsBadges:
  • sql quries

    i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.

    Yasir oracle5 pointsBadges:
  • 3 tier character report printing not possible in 10g

    i made a character report in 10g , if i run in report builder then its printing is fine. but when i print report using 3 tier (using pdf format) then all setting are disturbed.

    Yogender dba5 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • People Soft

    Is there a People Soft Tutorial available?

    Sil5 pointsBadges:
  • Stop Error (C000021a)

    I am receiving this stop error(C000021a) "windows logon process system process terminated unexpectedly" with win 2000 server. Safe mode and Last Known Good Conf. works fine. Is there any solution without reformating the HDD? I have ERD with me. Will that help me? Any advise on this would be highly...

    BinooDas123410 pointsBadges:
  • Looking for the user interface in SQL Server 2005 Developer Edition

    I just installed SQL Server 2005 Developer Edition and I can’t find the user interface. I’m looking for the place I’d type queries as I did in SQL Server 2000 Enterprise Manager. Where can I find the UI?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What causes ora-00904 error on valid fields when querying across dblink in a cursor

    I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the link and all of...

    Tom msu15 pointsBadges:
  • Nested SQL with multiple table join does not work with wildcard searches

    Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving nested...

    Masonyujr5 pointsBadges:
  • Need help with a slow pl/sql script

    Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ---------------------------------- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE;...

    Darrankavanagh20 pointsBadges:
  • How to exclude certain hours and certain days in a date range in oracle sql

    hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT f.col2,...

    Nida dean5 pointsBadges:
  • building a tree

    how do you build a tree in oracle application express

    Rwy265 pointsBadges:
  • Restoring offline backup

    How to apply offline redo log files to an off line backup which earlier to the offline redo log backup and recover system at less loss of data

    17383110 pointsBadges:
  • Oracle Developer 2000 Certification

    I have an experience of 8 years on Oracle & Developer 2000, but i have no certificate related it. Now i want to do certification. But what kind of track i should take ? I am cofused about it. Some body will help me for that?

    Kelp115 pointsBadges:
  • upgrading oracle 8i to 10gR2 with 3.5TB database size

    sirs, what is the best way to migrate a 3.5TB database from oracle 8i to 10gR2 on the same machine? the OS is AIX L5, with 10TB storage size

    Wynnsk85 pointsBadges:
  • problem with navigation in oracle forms using the ‘tab’ key

    we use oracle forms as the front end for a banking software and the users encounter a problem when they try to create a new record from the from the end. Whenever the users try to navigate between the fields by using the 'tab' key the system just does not respond and kinda hangs right there. No...

    Gnvraghavan5 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