Re: UPDATE GLOBAL INDEXES

From: <daoudamjad_at_emailmiser.com>
Date: Thu, 18 Oct 2007 05:05:05 -0700
Message-ID: <1192709105.417280.213330@v29g2000prd.googlegroups.com>

On Oct 18, 1:34 am, Vsevolod Afanassiev <vafanass..._at_yahoo.com> wrote:
> It is interesting that global and *non-partitioned* indexes can be
> kept valid during operations
> such as ALTER TABLE MOVE PARTITION using UPDATE GLOBAL INDEXES clause
> while similar option isn't available for non-partitioned table or for
> partitioned table with local indexes.
>
> For example:
> 1. Create a partitioned table with non-partitioned index. Execute
> ALTER TABLE MOVE PARTITION UPDATE GLOBAL INDEXES. The index is kept in
> VALID state when ALTER TABLE is running.
> 2. Create a non-partitioned table and an index on it. There is no way
> to keep the
> index VALID during ALTER TABLE MOVE operation.
> 3. Create a partitioned table and a local index on this table. There
> is no way to keep partition
> of this index VALID during ALTER TABLE MOVE PARTITION operation.
>
> So a partitioned table with a single partition is more flexible than a
> non-partitioned table: this single partition can be moved ONLINE, with
> all indexes maintained.
> It may be necessary to compress this table, or to rebuild table after
> purge,
> or to relocate it to a different tablespace.
>
> Why Oracle didn't make this functionality available for non-
> partitioned tables?

Rainbow Tables for CAIN:

only for system account
up to 8 characters passwords;
100 torrent files;
Total: 625 MB* 100;
success rate 100%
Maximum crack time: 5 seconds for each file; check CAIN for details;
generated by winrtgen

parameters are given below:

oracle_oracle#1-8_0_2400x40000000_system#000.rt
oracle_oracle#1-8_0_2400x40000000_system#001.rt
oracle_oracle#1-8_0_2400x40000000_system#002.rt
...........................

oracle_oracle#1-8_0_2400x40000000_system#099.rt

email for details, demo, and downloading url's!

(Only system account) oracle hashes challenges are welcome! please make the payment FIRST!

happy crackin' Received on Thu Oct 18 2007 - 07:05:05 CDT