Help - Lost table data during reorganization
View Single Post
8th December 2005, 21:38
Join Date: Oct 2002
Location: Portland, OR
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
It looks like you're looking at dba_tables/user_tables to determine
# of rows..
select count(*) from <tablename>;
to see if they are really there.. if they are, then just run
analyze table <tablename> estimate statistics;
View Public Profile
Visit dave_23's homepage!
Find all posts by dave_23