There's a discussion on my website about using the 'QUERY' option to limit
what gets exported (see Tips, Backup and Recovery, How do you export only
part of a table). It is not that easy: depending on your operating system,
you are going to have fun escaping the right characters to get them treated
properly as quote marks and so forth.
Regards
HJR
--
Resources for Oracle: http://www.hjrdba.com
===============================
"Gary YU" <gary.yu_at_istark.com> wrote in message
news:5483713a.0111200703.1d291be1_at_posting.google.com...
> Hi,
>
> I had a very big log table which I wanted to clear. It logs some event
> for the past year, I planed to clear it and only keep the latest
> month. The problem is, due to the size limit of the redo log, I cannot
> do a delete even on a day-to-day basis. I just wonder, is there a way
> I can export only part of the table(say, the last month), and totally
> truncate the table, then import the smaller datafile.
>
> I'm new to oracle, I knew Informix has such tools to export table
> using select statement and save to a text file, then import it. Does
> Oracle have the same tools?
>
> Thanks a lot!!
>
> Gary
Received on Tue Nov 20 2001 - 13:19:36 CST
