Uploads in Oracle 10g

150 pts.
Tags:
Oracle 10g
Oracle 10g administration
Oracle 10g Uploads
When huge files are being uploaded in Oracle 10g standard edition, query from end user has to be stopped. Is there a way out that I do not have to keep the database down for end user.

Answer Wiki

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

If you are loading data into a table then queries against that table must be stopped.

If you are inserting into that table, queries can continue.

There is a technique that has been around for a long time that you might look at….
Have two tables. Query against one while loading the second. This requires a table with the value in it as to which table to use. This “switch table” must then be referenced by the query and let it drive access to the correct table.

one example (and there are probably better ones.) …
<pre>
SELECT …
FROM TABLE1, SWITCH_TABLE
WHERE SWITCH_TABLE.COL =’1′
UNION
SELECT …
FROM TABLE2, SWITCH_TABLE
WHERE SWITCH_TABLE.COL = 2
</pre>

Discuss This Question: 2  Replies

 
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
  • carlosdl
    How are you uploading those files ? What happens if users are allowed to connect when uploading the files ?
    69,065 pointsBadges:
    report
  • Akansha
    ETL is used to upload these files. If users connect they sometimes see the data on screen and sometimes they do not see data on screen
    150 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