编辑oracle\ora81\sqlplus\admin\glogin.sql-- -- Copyright (c) Oracle Corporation 1988, 1999. All Rights Reserved. -- -- SQL*Plus Global Login startup file. -- -- Add any sqlplus commands here that are to be executed when a user -- starts SQL*Plus on your system-- Used by Trusted Oracle column ROWLABEL format A15-- Used for the SHOW ERRORS command column LINE/COL format A8 column ERROR format A65 WORD_WRAPPED-- Used for the SHOW SGA command column name_col_plus_show_sga format a24-- Defaults for SHOW PARAMETERS column name_col_plus_show_param format a36 heading NAME column value_col_plus_show_param format a30 heading VALUE-- For backward compatibility set pagesize 14-- Defaults for SET AUTOTRACE EXPLAIN report column id_plus_exp format 990 heading i column parent_id_plus_exp format 990 heading p column plan_plus_exp format a60 column object_node_plus_exp format a8 column other_tag_plus_exp format a29 column other_plus_exp format a44set autocommit on
如何设置?
还由一个问题:方案和表空间由多大区别?
-- Copyright (c) Oracle Corporation 1988, 1999. All Rights Reserved.
--
-- SQL*Plus Global Login startup file.
--
-- Add any sqlplus commands here that are to be executed when a user
-- starts SQL*Plus on your system-- Used by Trusted Oracle
column ROWLABEL format A15-- Used for the SHOW ERRORS command
column LINE/COL format A8
column ERROR format A65 WORD_WRAPPED-- Used for the SHOW SGA command
column name_col_plus_show_sga format a24-- Defaults for SHOW PARAMETERS
column name_col_plus_show_param format a36 heading NAME
column value_col_plus_show_param format a30 heading VALUE-- For backward compatibility
set pagesize 14-- Defaults for SET AUTOTRACE EXPLAIN report
column id_plus_exp format 990 heading i
column parent_id_plus_exp format 990 heading p
column plan_plus_exp format a60
column object_node_plus_exp format a8
column other_tag_plus_exp format a29
column other_plus_exp format a44set autocommit on