Reading, Deleting, Writing Rows to Oracle Data Base

pts.
Tags:
Windows
We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers in getting this accomplished would be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

First of all, what exactly do you mean when you say “Oracle database file” Do you really mean a Oracle table (like EMP, or DEPT), or are you talking about the database file in which Oracle stores its entire database?

You cannot read or write to an Oracle database file without an extreme amount of difficulty. It is a proprietary file format, with way too much intracacy involved for what you literally said in your question.

I’m actually pretty certain you meant an Oracle table within an Oracle database, not the database file itself. For this, you need to connect to the Oracle database running on that Windows 2003 machine, using a userid that has access to to the tables in question, when perform your data access using SQL.

Once you get yourself connected, you should then have access to the resources necessary to show you how data access/manipulation is done.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Alanwill
    To add to Jolora's response, if you are looking to copy rows from one database to another you should look into using database links. They will seemlessly allow you from one database to manipulate a table in another database all as if the both tables were in the same schema/database. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/ds_concepts.htm#15653
    0 pointsBadges:
    report

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