Tuesday, 26 June 2018

Creating Backup Table in Oracle

Below is the statement to create backup table :-

Create table xx_tab_backup as
select * from ra_customer_trx_lines_all


You can select any number of columns you want to create backup for or * to select all the columns