Re: Create New Schema??

From: Kai Horstmann <horst_at_werum.de>
Date: Tue, 21 Jul 1998 21:42:09 +0200
Message-ID: <35B4EF11.BF09628B@werum.de>

Doug Lewis schrieb:
>
> How do I create a new schema?? All I can currently use is SYS and
> SYSTEM, which is not my preference.
>
> Thanks,
>
> DTL
NEVER create objects for users SYS and SYSTEM!! Objects of user SYS are considered as data dictionary and therefore never exported with the export utility!

Always create own Users(schemas) to contain application data. (SQL command is CREATE USER...)
Give the users the rights at least to log in (GRANT CONNECT TO <USER>) and to create own database objects (GRANT RESOURCE TO <USER>).

Better before you create new users, create own tablespaces for user rollback segments, sort areas(temporary tablespaces) and user tables, indexes and other objects.
Spread the tablespace files over your physical disks if you have more than one.

Mark these tablespaces as default and temporary tablespaces for your users. (alter user <USER> default tablespace <XX> temporary tablespace <YY>;)

These are only a few hints. They cannot replace deeper knownledge about appropriate database design.

Good luck
Kai Received on Tue Jul 21 1998 - 14:42:09 CDT