Re: [Beginner]Can't see records in large table

From: Guyren Howe <>
Date: Thu, 16 May 2013 13:12:50 -0700 (PDT)
Message-ID: <>

Most of the larger tables are owned by a user called flexadmin. However, if I log in as flexadmin and do:

select table_name, num_rows from user_tables;

This user has over 500 tables, but the tables all have 0 rows.

I've logged in as sys and done:

grant all privileges to flexadmin;

So unless there's something peculiar going on, I'm guessing something went wrong with the import.

I did the import with a -full option, I think it was. But this was after I'd done the import with only one 32GB file so it failed.

If I look at the import log for one of the larger tables belonging to flexadmin, I get "All dependent metadata and data will be skipped due to table_exists_action of skip".

The obvious guess was that the failed import created all the tables but not the records, and when I ran it again, it skipped the extant tables. Which is reasonable, except for why the table is so big. Perhaps that's space it reserved?

The most obvious thing to do I guess is to blow away the database and start again, but it took so much faffing about to get to this point that I believe I'm fairly likely to wind up with something that's unusable that will take me days to fix again.

I can do that, but if there is a way to run the data pump import again and have it create the records I appear to be missing, I think that would be better. Received on Thu May 16 2013 - 22:12:50 CEST

Original text of this message