Hi, My table 'A' has 11 million rows . I created temp table 'B' same as table A and inserted rows upto 4 million from table 'A' using where caluse.
The data was inserted fine without any errors, But when Iam trying to do a row count on table 'b'.
selct count(*) from b.
But it is not giving me any output. It has been more than 30 min but still there is no output. Table A rowcount gives me in few seconds. Can any one let me know what the problem could be??
I did give the commit after inserting. I am logged into the same user in which I created the table, but still I am not able to get the row count. THe primary keys are disabled for table A and table B.
Table B do not have any indexes or any constraints.
I created table B as ..
Create table B (col1 number, col2 varchar(10)........ 15 columns)
TABLESPACE TS012 PCTUSED 75
FREELIST GROUPS 1