Re: recreating databases
From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/01/06
Message-ID: <4cl0ta$kg9_at_cougar.vut.edu.au>#1/1
: : Hi,
: :
: : I need to recreate an existing database. Due to space contraints, I
: : need to do it using user exports. I know that I will need to export/import
: : all users including SYSTEM. What about SYS .. should I export
: : and import tables and views owned by SYS, too ?
: :
: : I'm using Oracle 6.0.37...
Date: 1996/01/06
Message-ID: <4cl0ta$kg9_at_cougar.vut.edu.au>#1/1
: NORHISHAM BIN MAIN (med10054_at_leonis.nus.sg) wrote:
: : Hi,
: :
: : I need to recreate an existing database. Due to space contraints, I
: : need to do it using user exports. I know that I will need to export/import
: : all users including SYSTEM. What about SYS .. should I export
: : and import tables and views owned by SYS, too ?
: :
: : I'm using Oracle 6.0.37...
You cannot export objects belonging to SYS. When a new database is created, new sys objects must be created from the Oracle provided scripts. In 7.1.3 these are catalog.sql and catproc.sql. I think they're the same for 6.0.37. It's been a long time now since I've worked with 6. So the lesson to be learnt here is that each time a new database is created, (or old database recreated), you will always have new SYS objects. They cannot be exported/imported. So NEVER, NEVER create any user objects as SYS. Only do so when required by Oracle.
HTH,
Leng.
-- Leng Kaing DBA - Directory Technology P/L Email: lkaing_at_ventnds1.telecom.com.au Ph: +61-3-9892-9081 Fax: +61-3-9892-9344Received on Sat Jan 06 1996 - 00:00:00 CET