?duplicating database objects within same server

From: Peter Hiemenz <PeterHiemenz_at_compuserve.com>
Date: Wed, 29 Sep 1999 05:03:18 +0200
Message-ID: <VA.00000059.06b98c4b@hp>

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 - 22:03:18 CDT