Re: Moving Database Objects

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 09 Dec 1999 17:56:34 +0800
Message-ID: <384F7CD2.3F19@yahoo.com>

Mike Carter wrote:
>
> I need to transfer a series of database objects (including tables,
> procedures, triggers, sequences, synonyms, etc.) from one 8.1.5 database to
> another on a different server. Does anyone know of an easy way to do this?
>
> Mike
> mike_at_delriotech.com

If they are well segmented (ie associated with particular users) then export/import should do the trick.

Otherwise, using something like TOAD (www.toadsoft.com) to generate the appropriate DDL's may assist.

HTH
--

---

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 Dec 09 1999 - 03:56:34 CST