Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to partly export/import a table?
What version ? what platorm ?
If you're using 8i - check out the QUERY option with EXP
example : exp user/password tables=your_table query="where
timestamp=to_date()"
If you're on unix you should escape special characters like <,>,$ etc
"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 - 12:20:34 CST