• Importing Data in SQL Server 2000. “Integrity violation error” in RowID column

    Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the...

    Kpatel0 pointsBadges:
  • Oracle migration: What is the best approach to migrate a 24/7 8I database to a 9I database in a new box and minimize the downtime ?

    I am thinking on using a backup (cold/hot or RMAN) to the new box that is preloaded with 9I( + 9.0.5 patch) with a new instance same SID, same dbname, run the migration script and .. . how can I synchronize or serialize with the old 8I database that is still running after the migration 9I database?...

    Beginner90 pointsBadges:
  • Help with VBA Code for retrieving data from a table in an MS Access Database

    Hi, I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected...

    Suprababe0 pointsBadges:
  • Erros starting SQLPLUS after a no problems installation (oracle)

    I'm running Fedora Core 3 In my terminal I $ sqlplus and I'm prompted for my username and password. No matter what I type in, I get these error messages ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist It makes me think I've got my uname and password wrong but I don't -...

    Keithcybin0 pointsBadges:
  • Oracle ./runInstaller problem

    Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

    Asiankiwi0 pointsBadges:
  • Locate similar data in different oracle schemas

    I was told that there is some freeware (or really cheap software) that can find duplicate data in different schemas. My company has acquired a lot of smaller companies, but has not merged the data. Each company/application has its own oracle schema. For example, schema 1 has a table with a column...

    Cicssc0 pointsBadges:
  • Recovery to a Remote Site

    We take nightly full backups of an 9i database using RMAN. We plan to ship the backup tapes tapes and archive logs to a remote site. (We also use Dataguard between the two sites, but the question is not related to Dataguard). Question: If I were to lose the entire primary site (fire), can I use the...

    David440 pointsBadges:
  • Oracle 10g Standard on Win 2003 Server Standard – Shutdown database thereafter cannot Startup, require restart

    Hi there On server side + SQL*Plus tool! connect sys/pwd @sid as sysdba shutdown immediate or abort startup mount ORA-12528: TNS:listener: all appropriate instances are blocking new connection Use lsnrctl status - blockage - stop service + restart same error message. Other steps -->...

    ImraneA0 pointsBadges:
  • Connecting Oracle to Microsoft SQL

    Can anyone assist in connecting my oracle database to a Microsoft SQL server. This will be in the form of table linking. Please this is quit URGENT and your help will be very much appriciated. Thks, anthonio

    2419660 pointsBadges:
  • SQL Server equivalent of Oracle’s desc tablename command

    Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

    Kpatel0 pointsBadges:
  • Oracle 9i Instance and database creation from the command line in WIN NT 2000

    Hi, Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)? I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba". When I specify a...

    Sumeshs0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • Linux based CRM systems

    I know several companies are working on Linux based CRM systems, but are there any commercial grade complete CRM products available on the market today (March 2005)? Thanks

    Japaninsider0 pointsBadges:
  • PMP transitioning from tech oriented projects to business oriented projects

    I am a PMP with 10+ years experience in implementation oriented projects (rollouts, user moves, infrastructure, NetOps, etc.) for internal clients. I want to transition to business oriented projects (SAP, PeopleSoft, SOX, SW development, etc.) for external clients. I am fully familiar with PMI...

    Johnnylac0 pointsBadges:
  • 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 8.1.6.2 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:

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