Networks

Ask something
Discussion Locked

append new data to Oracle 7.3.4 database

0 helpful
7 replies

by huynhmdr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I import new data let say this Monday to this Wednesday into my current Oracle 7.3.4 database without corrupt the old database data?

Thanks,

Ryan

7 replies

by still_learning

I have not worked with Oracle before, but the two database products that I have used, have an Append command that imports data and adds it to the end of the database. Hope that this helps you - Steve

by rmrsalisbury

You don't say what format your 'new' data is in - Access, Excel, another DB etc - but assuming you can save or export it into csv format, Oracle has an Import utility which will do the job. In order to expand on more precisely 'how to...' I would ned a more detailed explanation of your particular problem.

by satheesh

What u can do is that.
Steps duing Export.
1.Create a temp tables from the schema which would contain the data from monday to wednesday this u can do using a column that contains a Date column.(any table will definitely have a column that can
hold a Date Column.)

2.Create an Export dump from a temp tables which has values from Monday to Wednesday.

Steps during Import.
1. Import the Dump into temp tables.
2. Write a procedure to transfer data from Temp Tables to the main table. By setting the Constraints = N option.
You can make use of the option 2 only when the integrity constraints needed not take effect.

With regards
S.Satheesh

This discussion is closed to new replies.