Re: IMPORT - how many passes?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 5 Nov 2003 17:50:34 +0100
Message-ID: <bob9or$55r$1@news.fujitsu-siemens.com>

"Brian Peasland" <dba_at_remove_spam.peasland.com> schrieb im Newsbeitrag news:3FA9294C.29FE3DDE_at_remove_spam.peasland.com...
> > Ok, but what happens to the SYS and SYSTEM schemata of
> > the database I'm importing into? and the performance views and all
> > that stuff?
>
> SYS objects won't be exported. And you really shouldn't try. SYSTEM
> objects will get exported and imported though. Your performance views
> and all that stuff are owned by SYS. They won't get exported, hence they
> won't get imported.

Ok, so nothing much can go wrong.

>
> > And what requirements must that database fulfil? Is the "create database"
> > statement enough or must I run catalog.sql too?
>
> You'll want to run CATALOG.SQL and CATPROC.SQL.
Thanks!
Volker Received on Wed Nov 05 2003 - 10:50:34 CST