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.
SQL> grant connect, resource to scott;
Grant succeeded.
SQL> alter user scott account unlock;
User altered.
Demobuild execution.
The script to create the tables
http://www.oracle-database-tips.com/demobld.html is located in
%oracle_home%\sqlplus\demo\demobld.sql
or
$ORACLE_HOME/sqlplus/demo/demobld.sql,
for either windows or unix.
How to run it / Cara menjalankan script demobld.sql tadi :
SQL> connect scott/tiger
Connected.
SQl> @?/sqlplus/demo/demobld.sql
Building demonstration tables. Please wait.
Demonstration table build is complete.
semoga bermanfaat yaa. ;)
--- Pada Sel, 30/3/10, hatake <[email protected]> menulis:
Dari: hatake <[email protected]>
Judul: [indo-oracle] menambahkan SCOTT database di Oracle - XE
Kepada: [email protected]
Tanggal: Selasa, 30 Maret, 2010, 3:23 AM
Tolong kakak minta bantuannya , masih nubie nih , gimana nambahain
database scott pada oracle-XE? soalnya pas waktu pertama kali nginstall adanya
cuma database HR ... ?? mohon penjelasan kakak2 ,,
Lebih aman saat online. Upgrade ke Internet Explorer 8 baru dan lebih
cepat yang dioptimalkan untuk Yahoo! agar Anda merasa lebih aman. Gratis.
Dapatkan IE8 di sini!
http://downloads.yahoo.com/id/internetexplorer/
[Non-text portions of this message have been removed]
