Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting Table Partition

Re: Exporting Table Partition

From: <oracledba_at_my-dejanews.com>
Date: Tue, 30 Mar 1999 21:28:32 GMT
Message-ID: <7drfll$813$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US