hello
i have a table with thousands of records , now i want to go for partition .i have to do without using logical backup that is create a new table and taking a backup of the records query wise and than dump it to the new table which is partitioned.
one of my colleage is not sure of the syntax but he said to use exchange to copy the records to the new table which is partitioned.
could you please help me with the correct syntax or help me out with a solution
thank you