Re: CREATE DATABASE

From: VT <vitti_at_hotmail.com>
Date: 1998/03/30
Message-ID: <01bd5bde$de5dd2c0$69da1ba1@vturchetti.infostrada.it>#1/1

Igor Sereda <sereda_at_spb.runnet.ru> ha scritto nell'articolo <351FFE53.1F4A817D_at_spb.runnet.ru>...
> Hello,
>
> i experiance some problems when creating database from the very
> beginning.
> ...
> First, i learned that there's very valuable file SQL.BSQ which i
 heard
> ...
> Then i decided that i should pass to Oracle file CATALOG.SQL to make
 up
> ..
> But now, when i run SQL*Plus and connect to the database it bursts
 with
> messages like 'package DBMS_STANDARD must be created before using

First of all, the file sql.bsq is not intended to be run directly. It is implicitly used by the "create database" command to build the core data dictionary.
After creating the database you only have a system tablespace; in general you should add other tablespaces, rollback segments and so on...
Before letting other users access your database you should run (connected as internal or sys):

- catalog.sql
- catproc.sql
- possibly other scripts according to your needs (e.g. catrep.sql so as

to use advanced replication, etc.)

Best regards Received on Mon Mar 30 1998 - 00:00:00 CST