Database Backup and Recovery (MOSC)

MOSC Banner

backup FGA_LOG$

edited Jun 24, 2014 3:32PM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓


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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center