Oracle Database Discussions

hi all,

i have create table and i inserted record also,then i deleted some record in that,

using flashback query i can able to check how many record is there before deletion.
select * from table as of timestamp or scn.

but iam inserting the data using flashback query like

insert into table(select * from prod as of timestamp or scn),

here,total record count is 8 in the table
deleted 3 record,balance 5 records

by using flashback query iam inserting record before deletion


iam using "insert into table(select * from table as of timestamp or scn)

after inserting record count is 13,
total table record count is before deletion 8 ,now i getting 13 record count,

i need 8 record count only,
anybody help me ,pl share ideas