A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes.
$ sqlplus /nolog
SQL> connect / as sysdba
Connected
Creating a New Schema
SQL> create user ctechz identified by ctehz11;
User created
Grant Permissions to user
SQL> grant create session, create table, create trigger, create sequence, create procedure, create view to ctechz;
Grant succeeded
Connecting to Schema
SQL> connect ctechz/ctechz11;
Connected
Granting table space to the schema
SQL> grant unlimited tablespace to ctechz;
Grant succeeded
Terima kasih telah membaca artikel tentang Oracle Schema Creation di blog Tutorial Opensource and Linux jika anda ingin menyebar luaskan artikel ini di mohon untuk mencantumkan link sebagai Sumbernya, dan bila artikel ini bermanfaat silakan bookmark halaman ini di web browser anda, dengan cara menekan Ctrl + D pada tombol keyboard anda.