Re: easiest way to copy one DB to another?

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
>
>chris

1. this will require you to precreate the schema
2. you can't exclude triggers and views from an import
3. In order to do that properly you would need to imp ... indexfile=<any filename> This will result in a sql script with all create index commands. In order to save resources you can edit it, and replace LOGGING by NOLOGGING
4. this doesn't make sense as explained above.

--
Sybrand Bakker, Senior Oracle DBA