| Computers Forum Index » Computer - Databases - Olap » Oracle 11g and Ascential DataStage 5.2.1... |
|
Page 1 of 1 |
|
| Author |
Message |
| rapaz... |
 Posted: Fri Sep 12, 2008 7:42 am |
|
|
|
Guest
|
Hello,
I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.
With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.
Have anyboy seen this problem?
Thank you very much.
-Ramón |
|
|
| Back to top |
|
|
|
| DA Morgan... |
| Posted: Fri Sep 12, 2008 6:37 pm |
|
|
|
Guest
|
rapaz wrote:
Quote: Hello,
I´m working in a DataWarehouse enviroment with Ascential DataStage
5.2.1 and Oracle 11g. We are trying to load information in a Oracle
database using DATASTAGE jobs. Our problem is with the commit. When
the job is runnig we dont see any rows in the database, it seems that
DataStage dont commit any change. But we have expecified 500 rows per
transaccion in the OCI component of the job.
With Oracle 9 and Oracle 10 it works but with Oracle 11 fail. In the
Jobs we are using the OCI component provided by Datastage.
Have anyboy seen this problem?
Thank you very much.
-Ramón
Why don't you take this up with the company that makes the product?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan at (no spam) x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org |
|
|
| Back to top |
|
|
|
|
