Re: Please help with export / import!

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Fri, 05 Nov 1999 18:38:51 +0100
Message-ID: <3823162B.FD979E76@xlink.net>

Hi,

kwiateks_at_juno.com wrote:
>
> Hello Smart One,
>
> I have a sun sparc 20 with an oracle database (8.0.5). I want to copy
> the entire schema, indexes, tiggers, data, sequences to a sun ULTRA
> SPARC database (version 8.1.5 AND different architecture than the sparc
> 20).
>
> I have a lot of sequences that I need to preserve the state of.
>
> Can I use export/import? Or what strategy would you suggest?

the best strategy is to call "exp userid=system full=y consistent=y", transfer the dump file, and "imp userid=system" the file. Be sure to set recordlength and buffer to sufficient values (e.g. 100k).

Best Regards!
--
uwe.schneider_at_xlink.net Received on Fri Nov 05 1999 - 11:38:51 CST