Oracleでスキーマ(schema)の使い方
操作コマンド
SQL> Gruant dba to scott
SQL> create tablekoyolist(name char(15));
Table created.
SQL> create table system.user_infotbl(name char(15));
Table created.
SQL> insert intokoyolist values('scott’);
1 row created.
SQL> insert into system.user_infotbl values('system’);
1 row created.
SQL> commit;
Commit complete.
SQL> conn system/manager
Connected.
SQL> select * fromkoyolist;
NAME
———-
system
SQL> ALTER SESSION SET CURRENT_SCHEMA = scott;
Session altered.
SQL> select * fromkoyolist;
NAME
———-
scott
SQL> select owner ,table_name from dba_tables where table_name=upper('user_infotbl’);
OWNER TABLE_NAME
—————————— ——————————
SCOTTkoyolist
SYSTEMkoyolist