Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting Table Partition
Hi,
You have to use ":" partition specification.
exp user/passwd file=filename tables=(table1:partition1,table2:partition2)
Hope this helps,
Bala
In article <7dqilc$4q4$1_at_plug.news.pipex.net>,
"Christopher Allan" <ghm81_at_dial.pipex.com> wrote:
> Is it possible in Oracle 8 to export a single table partition rather than
> the whole table.
>
> The reason I ask is that the table is too large to save on a single drive
> volume.
>
> CP
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 30 1999 - 15:28:32 CST