Purpose to use to the data extracted from the server, according to the daily data is inserted into the database (insert only updated data)

A problem?
Whether you need to implement this function use FTP, script, a stored procedure?

Question 2?
Should with what method is simpler, the stored procedure is written into a script, or script call a stored procedure, etc.,

Question 3?

Currently used to extract the corresponding wrote from import table fields to the new list, to achieve data extraction system time that day only, should how to write?

There is no system time this column in the original data,

CodePudding user response:

If it is isomorphic database, why not use dblink?

In addition, the third question I don't think is a technical problem?

CodePudding user response:

Not across the library, on the other side just database export the compressed file, the purpose of the compressed file to insert into my data according to the system time

CodePudding user response:

refer to the second floor qq_39047048 response:

not across the library, the other end is compressed file database export, the purpose of the compressed files according to the system time into my data

Compressed files should not use the corresponding application to extract the first? The text is extract from? Or you want to deposit into bfile?

CodePudding user response:

Yes, all I need to use the FTP command unzip the bag, then use script to upload, then insert a stored procedure

CodePudding user response:

reference 4 floor qq_39047048 response:

yes, all I need to use the FTP command unzip the bag, then use script to upload, then use the stored procedure insert

I think the problem is that the file is exactly what kind of file? Do you want to unpack? If after decompression is a text, can use SQLLDR such as more efficient ways to put in storage, of course, has a high requirement for text, garbage data could not handle

CodePudding user response:

Yes is the method with what you said, but there is no date table columns, import data, according to the system time to insert the data;
For example, there are nine data yesterday, today there are 10 data (including yesterday's nine data) and then today I would like to add that a data to insert to the table I need,

CodePudding user response:

refer to 6th floor qq_39047048 response:

yes, it is the method with what you said, but there is no date table columns, import data, according to the system time to insert the data;
For example, there are nine data yesterday, today there are 10 data (including yesterday's nine data) and then today I would like to add that a data to the inserted into the list, I need

Date from the list of listed price default values, set to sysdate

CodePudding user response:

refer to 6th floor qq_39047048 response:

yes, it is the method with what you said, but there is no date table columns, import data, according to the system time to insert the data;
For example, there are nine data yesterday, today there are 10 data (including yesterday's nine data) and then today I would like to add that a data to the inserted into the list, I need

Carefully watched, this meaning is like this:
(assuming you want to import the library text is the text), have no time to fields, but every day to get the full amount of data, namely contains today, yesterday, the day before yesterday... The data? Then you only need to put the data into new today? If so, should be in before they leave the new data to screen out ah,

CodePudding user response:

A problem?
Whether you need to implement this function use FTP, script, a stored procedure?
Using a script
Question 2?
Should with what method is simpler, the stored procedure is written into a script, or script call a stored procedure, etc.,
Use the script call a stored procedure
Question 3?
Currently used to extract the corresponding wrote from import table fields to the new list, to achieve data extraction system time that day only, should how to write?
Write a timer task of the job