Re: easiest way to copy one DB to another?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 21 Sep 2005 17:14:19 GMT
Message-ID: <433194c0.1025592500@localhost>

On 21 Sep 2005 08:17:37 -0700, "barneytoe" <barneytoe_at_gmail.com> wrote:

>This won't work as the target DB is on unix and destination is XP.
>
>I'm assuming I should do something like this then:
>
>1) import schema, not in FULL mode
>2) import data only, not the indexes, triggers, grants, and constraints
>3) import the indexes
>4) all other objects such as views, constraints, triggers etc
>

If you don't care about copying the actualy data, but do care about copying all the code/indexes/triggers

Just use imp/exp, and imp with ignore=y rows=n .......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Wed Sep 21 2005 - 12:14:19 CDT