• Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g :

    Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g : Current Environment : Operation System : Window NT4.0 Oracle : 8i (8.1.7) Developer 2K : Forms 6.0.5.33.0, Report 6.0.5.33.0 We have ERP System in house Developed. Everything working fine. Now we want to Migrate Oracle 8i (8.1.7) to...

    Swatis0 pointsBadges:
  • relocation – IT manager in West Africa

    Dear All, I have been selected for a position of IT Director of manufacturing company in a West Africa country (my home country). the organisation operation cocoa bussiness with farms; disstribution; factories in the country. The IT environment is multi site with AS/400 (my knowledge is fair since...

    Abidjan0 pointsBadges:
  • SQL generated by 4GLs vs. Oracle stored procedures

    We are attempting to adopt programming standards which would mandate the use of stored procedures in our Oracle 8i and 9i databases for data access. Application developers prefer to take advantage of the SQL generation capabilities of IBM's WenSphere and Compuware's Uniface. DBAs feel the security,...

    Stevewaltz0 pointsBadges:
  • Technical: Query Plan Problem in Oracle DB 9i

    I have a set of PL/SQL functions building a 7M row table. The last function adds around 0.5M rows by gathering data from two existing tables (0.3M rows each) and from rows already placed in the table being built. The rows are added by a cursor which constructs the new row and writes one at a time....

    EricThomas0 pointsBadges:
  • Developing a Java application(a batch)that transfers data from SAP to Oracle DB and vise versa. HELP ME PLEASE!

    Hello, I'm a student and a newbie. I wanna learn Java in relation to SAP-BAPIs. My Test db is Oralce and I wanna develope a small application(call it a batch) that stores SAP Jobs(e.g meta data) in to my test Oracle db. The application should also be able to do bidirectional transaction(from SAP to...

    Lysoka0 pointsBadges:
  • 8i external procedures and 9i listener configuration issues

    I currently have 2 versions of Oracle, 81740 and 92050, on an HP unix box (11.11 64bit). Callouts to 8i external procedures have been working fine with the 8i listener. Recently the 9i listener was brought up. In the 8i listener.ora, we were able to define 2 seperate external procedure SIDs,...

    Rainwater0 pointsBadges:
  • How to purge records from the database?

    I am a newbie to database programming and have been given this project where data older than 7 days need to be removed from multiple tables that the application uses. I am thinking about creating a stored procedure to do that and schedule a job that will run this stored procedure everyday. Not sure...

    Jinisha0 pointsBadges:
  • Stored Procedure Error

    This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ------------------------------------------------------------------------ -- SQL Stored Procedure...

    Jsbaig0 pointsBadges:
  • JD Edwards opening I need your help with

    We have not had the opportunity to meet personally, but I noticed your background in our database. I have an unusually challenging requirement to fill and I hope you may be able to point me in the right direction. My customer is looking for an experienced JD Edwards Systems analyst from the...

    JDESeeker0 pointsBadges:
  • Tunning of query

    insert into tblsap_history(select * from tblsap ts where ( (ts.css_database,ts.sap) in (select SUBSTR(source_account, 1, 2),SUBSTR(source_account, 3, 18) from ds_account a where a.source_system = 1 and ts.taig='ISY002' and (sysdate-required_by) >= 180 ) ) union all select * from tblsap ts where...

    Softwaredevelopment0 pointsBadges:
  • Oracle database authentication in VB

    Hullo every one. Am programming in VB6 and connecting to an oracle db. How can I get the database to authenticate users, maintain all the specified privileges in the database from my application? Thanx! Wana

    Wanaug5 pointsBadges:
  • ORA-03113 error while compiling Oracle packages

    Hi All Recently we migrated our PLSQL code from Oracle 8.1.7.0 to 9.2.0.4. While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and...

    Boball0 pointsBadges:
  • Performance Tuninig of a Select Query.

    Dear All I am facing a performance tuning problem on the following query: select a.col1 as OID from table2 b,table1 a where a.col1 = b.col1 and b.col2 = 1568673860 and a.col2 in (select col1 from table3 where col2 in...

    Tanmoychat0 pointsBadges:
  • switching between instances without down time

    I am installing a new warehouse. I will be running two instances on the same physical server. I plan to load data into one instance while the other is being used for reporting. At the completion of the load process, I need to point the new user connections to the just loaded instance and allow the...

    Lfelder0 pointsBadges:
  • Best IDE for building JSP pages

    This is just for educational purposes. I want to build some JSP pages for a university project, and I'm looking for a J2EE IDE (better if free), but I'm, not sure which is best or easiest to use. I have taken a look to Net Beans 3.6 and I like it, but it's too heavy for my computer. Also I tried...

    carlosdl84,495 pointsBadges:
  • Upgrading Oracle on Windows 2000

    I am preparing an Oracle upgrade from 8.1.7.4 to 9.2.0.5 on a Windows 2000 environment. The server has 3 instances on it, and the possibility of upgrading them one at a time is a real one. My question is, is it OK to just run the upgrade assistant against each database one at a time, and let it...

    Mljsher0 pointsBadges:
  • C# sample code for copying a table from oracle to ms sql with ODP.NET needed

    I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a datareader object...

    Mt690 pointsBadges:
  • Db2 to Oracle porting

    I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

    Dpd08090 pointsBadges:
  • ORA-01033 Oracle Initialization or Shutdown in progress & cannot log into sqlplus.

    My Database is in limbo at the moment and i'm trying to get it shut down properly and restarted. I'm getting the ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges....

    Jonnyopera0 pointsBadges:
  • Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?

    We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files...

    Onilke95 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