i want remove duplicate records from the base table with out using rowid concept.i have one solution this is..

first selecting unique records from the table.
now creating a new table with this unique records
then after dropping base table
now rename new table to old name

is it corret or not


Please advise for me.