Rem
Rem $Header: whdev/2.0/owb/shiphome/owb/patches/bug10316797/fix10316797.sql /main/1 2010/12/20 00:41:17 yuhhuang Exp $
Rem
Rem fix10316797.sql
Rem
Rem Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. 
Rem
Rem    NAME
Rem      fix10316797.sql - Fix the bug 10316797
Rem
Rem    DESCRIPTION
Rem      Add one more index on CMPScoPrpClasses to improve CCM Project Tree
Rem      init/refresh performance
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    NOTES
Rem      This script should be executed by OWBSYS.  After that, the repository owner should execute "Optimize Repository" 
Rem      to make this work.
Rem    Usage:
Rem      sqlplus> conn OWBSYS/<OWBSYS PASSWORD>
Rem      sqlplus> @fix10205394.sql   <tablespace name, where the new indexes will be stored>
Rem      e.g.  Loging OWB Client with <Repos Owner>/<Repos Owner Password>
Rem            Click "Tools" -> "Optimize Repository"
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    yuhhuang    11/19/10 - Created
Rem

set serveroutput on size 999999
set line 300
 
ACCEPT tndex DEFAULT 'USERS' PROMPT 'Tablespace for creating indexes :[USERS] '

create index IDX_SCOPrpClassBusName on CMPSCOPrpClasses (WorkspaceID, s2_1, s4_1) parallel nologging compress tablespace &tndex;


@../../reposasst/SnapshotCreateRestore.plb