Veritas Storage Foundation for Oracle 5.0 Graphical User Interface Guide, HP-UX 11i v3, First Edition, May 2008
To move datafiles
1
Access the Database Dynamic Storage Tiering Move Datafiles wizard.
See “To access the tiered storage movement wizards in the Java GUI”
on page 30.
The datafiles and their assigned storage classes display in the Move Datafiles
wizard. To sort, click on column headings.
2
Select the datafiles to move.
3
Select the storage class to which the datafiles will be moved.
4
To assign the selected datafiles to the selected storage class, click Set class.
5
Repeat as needed for each class of storage until all datafiles are assigned
correctly. A blank storage class indicates the tablespace is not moved.
6
To move the datafiles, click Finish.
Moving table partitions
You can move table partitions from one storage class to another. You must define
Database Dynamic Storage Tiering parameters before you can move tablespaces.
To move table partitions
1
Access the Database Dynamic Storage Tiering Move Tables Partitions wizard.
See “To access tiered storage parameters wizards in the Java GUI” on page 29.
2
Set the correct owner of the table. SYS is the default Schema Owner which
must be defined to generate a correct table.
3
Enter a table name.
4
To get a list of partitions, click Get partition.
5
Select the table partition to move. When a table partition is selected, the
tablespace displays.
6
Select the storage class to which the table partition will be moved.
7
To assign the selected tables partition to the selected storage class, click
Apply.
8
Repeat as needed for until all tables partitions are assigned correctly.
9
To move the table partitions, click Close.
Getting reports for Database Dynamic Storage Tiering
Reports available in the GUI for Database Dynamic Storage Tiering include:
Tiering storage for databases
Getting reports for Database Dynamic Storage Tiering
96