You are here:
I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).
I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
BS in MIS
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| Jing | 11/11/09 | 10 | 10 | 10 | 10 | Thank you very much! |
| Jing | 11/11/09 | 10 | 10 | 10 | 10 | VERY quick reply and very helpful |
| Jing | 11/10/09 | 10 | 10 | 10 | 10 | Very quick reply and very helpful |
| prath | 08/28/09 | 9 | 9 | 9 | 10 | |
| sharad | 08/24/09 | 10 | 10 | 10 | 10 |
Jing, Assuming that the line_id is the primary key of the table. You can add an additional statement to the original code (in the first reply) to get the data that are added in Table2 (today). SELECT
Jing, The solution that I had before is assumed the line_id is unique. Without an unique column, there is no way to identify if new data is added or data has changed from table1 and table2. What is
Good day Jing, Here is what you can do TABLE1 - data from yesterday TABLE2 - data from today The following query will return -- Added to table2 -- Remove from table2 but exist in table1
Good day San I assume that you are using Oacle10gXE on WIndows Platform. There is no table to store the name of all the DB on your computer. However, in the Services (Start->Settings->Control Panel->Administrative
Good day This is what I understand from your question. (1) Configuration of DG Physical Standby (2) Physical Standby will only act as Read-only database (3) Need to create Standby Redo log files
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.