Salim berbagi…. tempat belajar dan berinteraksi….


Menambahkan Schema SCOTT di ORACLE
April 6, 2010, 12:26 AM
Filed under: ORACLE

Berikut ada artikel dari Rindra🙂, yang berguna untuk menambahkan schema SCOTT di Oracle. By default pada saat install Oracle database schema SCOTT sudah otomatis ada berserta object-object nya, tapi kalau kehapus, nyelip, dll dan ternyata gak ada, ya artikel berikut bisa membantu. Thanks to Rindra, jadi kapan nih Ndra ? hehehe

Scott schema creation / Membuat user/skema scott :

Create the scott user on your database if it does not already exist.

Connect to the database as a dba user, like sys or system.

SQL> create user scott identified by tiger

default tablespace users temporary tablespace temp profile default;

User created.

Selengkapnya…Scott schema creation


Leave a Comment so far
Leave a comment



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s



%d bloggers like this: