Re: Sys and System

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 15 Jul 2006 23:07:42 GMT
Message-ID: <Xns9801A415596E8ianalvistahotmailcom@70.169.32.36>

ujangmz_at_gmail.com wrote in news:1152996187.907149.163630 @b28g2000cwb.googlegroups.com:

> Hi everyone,
>
> What is the difference between sys and system? And which one is more
> powerful?
>
> If I want to use EXP to create a dump file and then use the dump file
> with IMP to recreate the database in another machine,

<nitpick>
IMP does NOT (re)create any database.
First the database needs to be created "manually". Next IMP can be used to populate the database. </nitpick>

IMP is a marginally acceptable tool to clone an Oracle database. When PK/FK constraints exists, the order in which tables are imported MATTERS!
Other caveats/problems exist when using IMP. Received on Sat Jul 15 2006 - 18:07:42 CDT