• SQL Question

    I am migrating a query from MySQL to Oracle 9i. The query returns the error: ORA-00904: ?Y?.?CATEGORYID?: invalid identifier error message. Which means the column name entered is either missing or invalid. The SQL is below, if anyone can help me resolve this problem, your assistance would be...

    Tlroper0 pointsBadges:
  • SAPDBA not working in ORACLE database

    Dear BASIS Experts, SAPDBA is not working in one of my Server . When I run it gives the error The environment variable NLS_LANG =american_america.we8dec differs form DB value AMERICAN_AMERICA.WE8DEC. Adjust the environment according to DB value !. SAPDBA terminates because data corruption would be...

    PANTSK0 pointsBadges:
  • Problem Migrating from RBO to CBO.

    Hi everyone, I'm trying to migrate from RBO to CBO on an database. The problem I am running into is a little wierd. Some, not all, queries that have a distinct or a subquery in it doesn't return results. How do I get around this and what is happening? Example: SQL> select 2 b.po_id, 3...

    Dansken0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Installation of Oracle9i client

    How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

    Barusame0 pointsBadges:
  • SYS account problems with 9i

    Hi, When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error. Surprisingly, I can log in as SYSTEM and another DBA account. The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not...

    Sumeshs0 pointsBadges:
  • Slow PL/SQL query

    I'm running the following query against two tables residing on an Oracle 8 database. The query takes too long (over an hour) to run. Both tables are indexed - however the main table SALES.SO is HUGE. Does anyone have any suggestions as to how I could improve this query so it can execute faster....

    Appioriley0 pointsBadges:
  • Domino Database Last Used

    Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

    Coachkaz0 pointsBadges:
  • 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:

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.