Re: [Beginner]Can't see records in large table
Date: Thu, 16 May 2013 13:12:50 -0700 (PDT)
Message-ID: <62799c53-a3c3-40f4-bbd2-7a313275507b_at_googlegroups.com>
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