moving items between databases

Dear Everyone,

how can i move items such as indivual tables, stored procs, functions, sequences and other user defined bits and pieces between

1. schemata within a database instance?
2. tablespaces (this is so i can shuffle tables/indexes etc to different disk drives)?
3. database instances?

in ms sqlserver, it is very easy to move single items between databases using the DTS import/export wizard.

in our current standard 9.2 version, tables can be moved, but not other user defined objects. in the enterprise demo version i was able to use change management wizard for single items.

any and all advice appreciate - pl/sql code earns my most grateful thanks

edwinah63

pls remove h from edwina if sending an email reply :) Received on Tue Nov 04 2003 - 00:50:21 CET