Export and purge table

[kababoom]

Hi All,
I am new to PLSQL. I am posting this query.

Wat i need : to purge and export oracle table data which is more than 1 month old onto a csv file

Thks for any advice :)

[debasisdas]

First create a table with same structure as of the main table.
Copy the required data to the new table and Delete from old table using PL/ SQL
Then use Export utility to export the data to a flat file.

[kababoom]

First create a table with same structure as of the main table.
Copy the required data to the new table and Delete from old table using PL/ SQL
Then use Export utility to export the data to a flat file.

Thks for the info but do u have any sample script so as to get me started on it?

Thks :)

[amitpatel66]

Thks for the info but do u have any sample script so as to get me started on it?

Thks :)

Kababoom,

You start implementing the logic provided to you in the above POST.
In case of any issues you face, do let us know, we will put you on track from there on!!

Thanks!!