Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xuewei

    Tables Comparison

    Hi AccessAce, I figured out the method to detect changing: SELECT Table2.ID, table2.Name, table2.Address, table1.age FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID WHERE table1.Name <> table2.Name OR table1.Address <> table2.Address OR table1.age <> table2.age; Thank you for your...
  2. xuewei

    Tables Comparison

    Thanks a lot, AccessAce, I think it should work and I will try it later. I will let you know the results after I figure it out. Hava a great day! Xuewei
  3. xuewei

    Tables Comparison

    Hi AccessAce, Your suggestion is one possibility to find the changed records. I will try it later. At the same time, do you think if I can create a procedure and use VBscript to do that? Thanks Xuewei
  4. xuewei

    Tables Comparison

    Hi AccessAce, Thank you very much for the solutions. I tried it, it works fine for the &quot;add&quot; and &quot;delete&quot;. I just changed a little bit of the SQL: SELECT Table1.ID, table1.Name, table1.Address,table1.age,&quot;Delete&quot; as Action FROM Table2 RIGHT JOIN Table1 ON...
  5. xuewei

    Tables Comparison

    Hi AccessAce, Thank you for your response. I tried your suggestion. Using the Find Unmatched Query Wizard, we can find records in one table that don't have related records in another table. However, I want to find not only added records, but also changed and deleted records. Do you have...
  6. xuewei

    Tables Comparison

    Hello, I have two tables in Access database with the same definition. For example, table1 and table2 have exactly the same data fields but have some different records. I want to find what records have been added, deleted, or changed in table2 compare to table1. Are there any methods to do the...
  7. xuewei

    Why this PL/SQL very slow?

    Hi Turkbear, Thank you for the response. There are 68650 records in gis_data and 66000 records in mail_out. They are not indexed. The database is Oracle9i running on Windows2000. For that statement, it run more than 8 hours and I still can't get results. I try to run Explain Plan on the...
  8. xuewei

    Why this PL/SQL very slow?

    Hi, I have a simple question about a pl/sql as following: update mail_out pmo set pmo.subdivision = ( select gd.subdivision from gis_data gd where pmo.apn_9 = gd.apn); When I run it from SQL*Plus, it seems run forever and I can't get any results. Can someone give me some suggestions...
  9. xuewei

    &quot;if .. then .. else&quot; in Oracle Warehouse (possible workarounds)

    Hi, But DECODE will not work at OWB. You can use CASE instead. Regards Xuewei
  10. xuewei

    Installation problem on Workflow

    Hi, I try to install workflow2.6.2 that comes with Oracle9iAS9.0.2 in Windows2000. There are Oracle9iAS9.0.2 infrastruture and Oracle9i Development Suite2.0.9.0.2 installed in the same computer. I always get error &quot;Error in writing to file c:\Program...
  11. xuewei

    Empty table after load the data in OWB

    Hi, I have a question about data loading in Oracle Warehouse Builder(OWB). I have a very simple testing that only include one source table and one target table. I deploy the scripts and register the job in OEM. But, after I run the job, there are no data in the target table. There are no...
  12. xuewei

    Empty table after load the data in OWB

    Hi, I have a question about data loading in Oracle Warehouse Builder(OWB). I have a very simple testing that only include one source table and one target table. I deploy the scripts and register the job in OEM. But, after I run the job, there are no data in the target table. There are no...
  13. xuewei

    Read Only Database

    Good Morning Robert, Thank you! It works. Xuewei
  14. xuewei

    Read Only Database

    Hi, I have a simple question. I have some Access Databases. I burned them to a CD-R. When I try to open them from the CD or even copy them to hard drive, the database always &quot;Read Only&quot;. I couldn't open the database. Please tell me why and how can solve this problem. Thanks Xuewei
  15. xuewei

    Oracle Warehouse Builder deployment problem

    Hi, I am trying to run a simple mapping to transfer data from one Oracle DB into another Oracle DB(Warehouse). There are not errors when I validate the mapping. But, I always get an error &quot;PL/SQL: ORA - 00942: table or view does not exit&quot; when I attempt to deploy my PLS scrip that...
  16. xuewei

    Oracle Warehouse Builder

    Hi, I am trying to evaluate OWB. But, when I deploy the project, I always got an error:&quot;Loading of data across database link is not supported&quot;. My source database is Oracle8i and my target database is Oracle9i. Please tell me what this error mean? Thanks Xuewei

Part and Inventory Search

Back
Top