Backing up and restoring HP Systems Insight Manager 7.x or greater data files in a Windows environment

White paper | HP Systems Insight Manager 7.x
16 | March 2013
14. The script output is spooled to the fix_empty_tables.sql file in the directory from
which you executed sqlplus.
If you want the file to be spooled to a different location, in the spool statement, specify that
location (for example, C:\temp. In this case, the statement would be as follows:
spool ‘C:\temp\fix_empty_tables.sql’
Figure13: Script for including all empty tables
15. Using sqlplus, run the generated sql file using the following commands:
Sqlplus <dbuser>/<dbpassword>
>@fix_empty_tables.sql;
>quit;
16. Running the script alters all of the empty tables. If the script fix_empty_tables.sql is
located in the directory C:\temp, specify the full pathname in the command. For example,
instead of entering @fix_empty_tables.sql, enter the following:
@’C:\temp\fix_empty_tables.sql’
Figure 14: Altering the empty tables
17. Export the tables using the Oracle 11g exp utility. This time, none of the tables will be
skipped.