Re: How to export sequences with exp ?

how about this(yes i read u didnt want to exp db but at owner level is that ok? but is it feasible with rows=n?)

on solaris strings is brain dead with lines > 1023 bytes, you've been forwarned.

mkfifo x.pipe

strings < x.pipe | grep "CREATE SEQUENCE" > sequences.txt

exp userid/password file=x.pipe rows=n ....

joe

Andreas Jung wrote:

> I need to export some sequences with exp. But I don't want to export the full
> database to get the sequences exported. Because sequences are not bound
> to a table "TABLES=..." don't export a sequence.
>
> Any idea how to do this ?
>
> Thanks,
> Andreas
>
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 06 2000 - 12:24:45 CDT