Defining Multiple Index Locations

Use this procedure to define multiple index locations for all indexes on a table.

To define multiple index locations

  1. Start the SQL utility.

    At the command prompt, type:

    sqlplus username/password

  2. Make changes to law_dba_index by issuing SQL statements:

    update law_dba_index

    set tablespace_name = 'newtbspace'

    where index_name = 'index'

    go

  3. Drop and rebuild the index using the new definition. At the command prompt, type:

    bldora11ddl / bldora12ddl -URI dataarea [systemcode [filename]]