Replication from DB2 to Oracle
Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number of bytes used by number data type
Guru's I want to find out the exact space occupied by a number field. E.g I want to find out the space occupied by a field NUMBER(7,2). I know oracle has an alogorithm to figure that out . A quick response would be highly appreciated RJ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7.4 to 9.2
Guru's We are planning to move to 9i from 8.1.7.4 in the near future. The two options we are considering are a) Migration from 8.1.7 to 9.2 b) Install 9i and then use export , import to get the data from version 8i. If my memory serves me right I remember reading an article somewhere which says that we could not use all the new features of 9i if we went ahead with the migration path. Could you please provide your inputs as to which way is better than the other with pros and cons of both. Thanks in advance. Rishi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partitioning
We have a table with around 80 million rows. The table has been partitioned by hash as there is no clear way of partitioning depending on range etc.. The data is very unevenly distributed in these partitions. Some of them even have 3 times the number of rows as compared to the other partitions. This application is being ported from Informix to Oracle (9i R2). In informix the dba's had partitioned the table based on a function . He was taking the mod of the number ( dividing by 10 ) . The values were then placed in either of the 10 partitions ranging from 0 - 9. This really gave us very good distribution of data .Can we achieve something similar in 9i with list partitioning. TIA Rishi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
count(*)
Hi Gurus, In one of our insert intensive application we are inserting around 3-4 million rows / hour. Also this app needs to do a count(*) of the tables every 10 minutes for verifying some application based logic. This is really killing us and it takes a lot of time. Can you please guide me to a direction ( built in functions or something similar). Actually this app is being ported from Informix. Informix can somehow keep a trak of the count(*) of a table in its header somewhere. And yes I have tries count(1) , count(indexed_column) etc. Thanks In Advance. R.h -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle OPS and IBM VSD
Absolutely false. You can always reuse the space if you drop the tablespace. Thanks !! Rishi -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Monday, August 19, 2002 8:48 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle OPS and IBM VSD Once you allocate a tablespace within a VSD (Virtual Shared Disk) file system, can you ever drop the tablespace and re-use that space for something else? (ex: chaining is a huge issue at this site, and there is not enough rollback space to analyze some of the table for chained rows... could I create a temporary tablespace with a large rollback segment to analyze the table for chained rows, and fix the table?) I heard, third hand, that this was not possible... I'm just looking for confirmation that this is true... or false. Oracle 8.1.7 OPS. AIX 4.3.3 VSD Filesystem (I tried IBM, but they just pointed fingers.) Thanks!! Nick