backup FGA_LOG$
Hi all,
I have NOT been able to backup this table. It has 6.7 million records and before I purge, I need a backup. I tried the following methods:
1. CTAS does not work as it it has LONG datatype and same goes with insert
eg: insert into backup_fga_log$ (select * from fga_log$);
insert into backup_fga_log$ (select * from fga_log$)
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
2. copy from sys/123@sctdev to sys/123@sctdev replace backup_fga_log$ using select * from sys.fga_log$;
Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)