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.
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.