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...
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...
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 "Error in writing to file c:\Program...
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...
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...
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 "Read Only". I couldn't open the database. Please tell me why and how can solve this problem.
Thanks
Xuewei
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 "PL/SQL: ORA - 00942: table or view does not exit" when I attempt to deploy my PLS scrip that...
Hi,
I am trying to evaluate OWB. But, when I deploy the project, I always got an error:"Loading of data across database link is not supported". My source database is Oracle8i and my target database is Oracle9i. Please tell me what this error mean?
Thanks
Xuewei
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.