sql> col object_name format a20;
sql> select object_name, object_type from user_objects;

*db 링크만들기

remote로 dbms 사용
sal> create database link remote_db connect to scott10 identified by tiger using 'ora92';

sql> select * from tab@remote_db;

*SID : DB명

*유저만들기
create user scott10 identified by desire;

*pw변경
alter user scott10 identified by tiger;

*생성된유저에 권한부여
grant connect, resource to scott01; <-connect, resource가 가진권한부여

grant dba to scott01;    <- dba 권한부여

*스크립트 가져오기
@$HOME/sqlplus/demo/demobld.sql

$HOME/sqlplus/admin/glogin.sql
~~~~~~~
define _editor=vi
....
~~~~~~

*이전에실행한 sql문수정
ed

*수정한 sql실행
/

*define내용보기
sql> define

*db설치환경 보기
sql> select * from nls_session_parameters;