. 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
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:
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
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.
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
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