• Database and Web Server Technology Choices for Small Database Application

    Hello, We are developing a small web-based database application that will need to be accessed by all department staff and managers (maximum 100 clients). Internet access to the database from outside the Agency is not required. It is not desirable to install any client software other than MS-Windows...

    Mmosystem0 pointsBadges:
  • Oracle Application Remote Administration

    Hello Sir/Madam/Mrs/Ms, i'm not sure whether is this the right platform asking my type of questions, but just go ahead. I have an Oracle database server and application server at Premise A. Right now i'm in Premise B which is geographically apart from Premise A about 365km. I want to access Oracle...

    Mofazha0 pointsBadges:
  • error on instaling grid on XP

    i have a oracle database 10g in windows XP, but when i try to install the grid control always give me this error: invalid version: to be used for management repository, the database must be version9.2.0.4.0, version 10.1.03.0, or a patch release for one of those versions.

    Fbecerra0 pointsBadges:
  • creating a user in oracle 8

    Hello I am doing a project and i want to practice or test a different senerios in my project which is in d2k and oracle 8, here my problem is , problem 1) in my system oracle is installed and i want to create a new user but it is not allowing me to enter as system/manager and in past i had created...

    Saeed790 pointsBadges:
  • 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:
  • Wireless University

    I work at a large, urban university. We are looking to upgrade our whole IT infrastructure. We hired a consultant group and they feel it will take a quarter of a billion dollars to accomplish it. I want to find cheap, faster, better ways to upgrade. Also, I want to serve students, faculty and...

    WirelessUniversity0 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:
  • 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...

    carlosdl68,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:

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