vi $ORACLE_HOME/sqlplus/admin/glogin.sql

 

#define
SET PAGESIZE 80
SET LINESIZE 170
SET TIMING ON
SET TIME ON
SET VERIFY OFF
SET EDITFILE /tmp/bufferfile.sql
DEFINE _EDITOR=vi
ALTER SESSION SET nls_date_format = 'YY-MM-DD HH:MI:SS';
SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER'>'
SET FILE_NAME FOR A50
SET TABLESPACE FOR A30
SET NAME FOR A50
SET SEGMENT_NAME FOR A20
SET OBJECT_NAME FOR A20
SET VALUES FOR A50