Updating Oracle DB offline using ASP

Hi all,

I need you help here. We are in a process of designing a solution using ASP with Oracle DB. The application has two modules developed by ASP.NET , one for searching the DB and the other for updating. the remote users can login to the application and access the DB online to search. However for updating the DB, users are not allowed to updated online, the update should be done off line where the data will be stored on a separate DB (let us call it Temp DB), then the admin will check the data by accessing  the Temp DB using ASP form and once, it is validated, and admin click ok, the data should be exported to the Oracle DB to update the related records.

My questions are:

- Can we do that?

- What is the detailed solution? technology used?

- How the the data can be exported from the Temp DB to Oracle DB and deleted from the Temp DB in one click (when the Admin validate the data)

I would appreciate your immediate feedback.

Regards,

Mounir 

Why not creating two databases in Oracle, both Temp and Original.

When the Admin will validate data from Temp database table, You can easily transfer that data into Original like this

INSERT INTO Original..TableName --with two dots

SELECT * FROM Temp..TableName --with two dots

As per the online/offline matter, I would recommend to separate this into two applications for better security. One application for those who will access the ASP.NET web application to Search In, and another ASP.NET web application which will run on intranet on your local domain aimed for the Admins and others in this domain.

Regards,
Hajan

Thanks Hajan for your quick reply.

The issue here is that the application has been already developed by another company, it is one application for search and update and used internally. Now they want to extend the service to external usere over the internet, but they don't want to allow the external users to update online, they want the Admin to validate the data before transfer it to orginal DB.

Please adivse.

Thanks

Mounir

What business logic they have made previously? Can regular users update the content of the website?

If yes, there is probably a module for doing that purpose. If not, still, someone can, so, if you want to make extension so that the Admins can manage this by the given requirements, as I said, connect the application to a database which is going to be used online. Then create module (UI) from where Admins can see what updates has been done to the Temporary database (which will be online) and the module should include functions using which Admins can transfer the data to the Original database (used in Intranet) or delete the data from the Temp.online database.

This is just a random idea,  even though, knowing the real structure and entire design of the application is necessary to decide what is the best way to extend an existing application with new features.

In my previous post, I've showed how you can copy data in SQL Server DB, but for Oracle, you will need to make link between databases, especially if the dbs are on different servers.

Here is one good article for creating links between Oracle Databases: http://searchoracle.techtarget.com/tip/How-to-create-a-database-link-in-Oracle