May be Cartesian Join [message #266786] |
Tue, 11 September 2007 11:41  |
feroze
Messages: 144 Registered: September 2005 Location: chicago
|
Senior Member |
|
|
Hi,
What i am trying to do is rename the partitioned indexes to be
same the table partition name, as we are adding new partitions to the table so the new ones will not match the old index partition names, so before adding new partitionst to the table i want to rename the index partitions,
It looks this select i have is doing cartesian Production gets multiple rows, what is missing in this
select 'alter index ' || c.index_name || ' rename partition ' || c.partition_name ||
' to ' ||b.partition_name from
user_indexes a,user_tab_partitions b,user_ind_partitions c
where a.table_name=b.table_name
and a.index_name=c.index_name
and a.PARTITIONED='YES'
and b.table_name='ABC'
Oracle is 9.2.0.7
Thanks
[Updated on: Tue, 11 September 2007 11:42] Report message to a moderator
|
|
|
|
|
|
|
Re: May be Cartesian Join [message #266801 is a reply to message #266798] |
Tue, 11 September 2007 12:20  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Rename is just an update in the dictionary, it will lock dictionary rows not the index itself (or during a very short time).
ONLINE is useless (I don't even know if you can specify it in this case).
Regards
Michel
|
|
|