Re: Export from one server to another...

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 13 Jan 2000 18:44:34 +0800
Message-ID: <387DAC92.19DD@yahoo.com>

Majken Longhi wrote:
>
> How do I move my Oracle DB from one server (my NT server with Oracle8i )
> to another server? If I export, what about my procedures, packages and
> sequences?
> I know my tabels and users are following with export. But what about the
> rest?
> I want to move it all, how do I do that?
> Thank you...
>
> Majken

Check the server utilities manual

exporting a schema includes all PL/SQL, views, indexes, constraints, triggers etc

export will full=y will export the lot
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 13 2000 - 04:44:34 CST