Re: ?duplicating database objects within same server

yes.. you can achieve it by import and export to replicate the database object owned by one user to another. The step is:

1. export the object that own by userA
2. create userB and set the default tablespace os userB to the tablespace which you wish your objects to be set up in.
3. import the object to userB as imp sys/change_on_install expdat.dmp fromuser=usera touser=userb <other option>

That's it!

HTH Winnie Liu
DBA
Infonet Services Corporation
mailto:winnie_liu_at_infonet.com

Peter Hiemenz wrote in message ...
>I need to transfer all database objects (tables, views, triggers, SPs)
>of a tablespace owned by one creator to another tablespace with another
>creator on the same server. Can it be done using exp/imp? But as told,
>the creator of the objects in the new tablespace must be different?
>
>I need to do this, as a software program is installed twice for two
>departments on the same server but each department needs to have their
>own data.
>
>Later all data and database objects need to be transferred to another
>server.
>
>What's the best or recommended way to do this?
>
>
>
>Peter Hiemenz
>Hilden near Dusseldorf
>
>HMS Planung & Automation GmbH, Duisburg, Germany
>
>Peter.Hiemenz_at_t-online.de
>PeterHiemenz_at_compuserve.com
>
>
Received on Tue Sep 28 1999 - 23:47:26 CDT