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
15 | March 2013
In the query, enter the database user name in uppercase letters. For example, if the database
user name is 'test2', enter 'TEST2' in the query because that is how it is stored in the
database.
The query would look like this:
Select table_name from dba_tables where owner=’TEST2’ and
num_rows=0;
Note:
If you enter the following, without correct capitalization of the database user name, the
query might not work:
Select table_name from dba_tables where owner=’test2’ and
num_rows=0;
Figure 12: Locating empty tables
Any tables returned by the query are empty tables that will not be exported by the Oracle
11g exp utility.
12. To avoid the problem of empty tables not being exported, make the tables visible to the
Oracle 11g exp utility by executing the following command for each empty table:
Alter table <table_name> allocate extent;
After the tables become visible to the exp utility, they will be exported.
13. Several tables might be empty. To generate a script that includes all of the empty tables,
enter the following:
Sqlplus <dbuser>/<dbpassword>
>set echo off;
>set feedback off;
>set heading off;
>set pagesize 0;
>spool fix_empty_tables.sql;
>select ‘alter table ‘ || table_name || ‘ allocate extent;’
from dba_tables where owner=<dbuser> and num_rows=0;
>spool off;
>quit;