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 :)
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 :)