• Lost Passwords in Oracle

    I have joined a company very recently who deploy their product on both Oracle and SQL Server platforms. Theyt seem to have no clue about their dba access passwords for Oracle. How do I get to these passwords? Is there a backdoor or utility which can help me get the passwords on these databases?...

    Sumeshs0 pointsBadges:
  • oracle performance tunning

    Anyone who can share an experince with session_cached_cursosrs: conditions to use, value & desired results - will get a virtual drink. TIA!

    Xlander50 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Data Architect career path

    I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to...

    Guguru0 pointsBadges:
  • Unix ODBC Drivers

    I am looking for an inexpensive way to do a pull of Sqlserver data into Oracle using Native Oracle Sql Statements to select the data from Sqlserver. This request would be easy to fulfill if there were an ODBC driver for Unix. I have found such drivers but they are expensive ($4000 per CPU on Unix...

    Jk666380 pointsBadges:
  • 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., version, 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, Report 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:

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.