LINUX下使用指令碼直接執行SQLPLUS命令(root使用者下)

select * from tab;
exit
EOF" > /home/oracle/111.txt  2>&1

開機自啟動ORACLE
vi /home/oracle/start_db.sh
vi /etc/rc.local
sh /home/oracle/start_db.sh





測試：
在oracle使用者下
sqlplus -s scott/tiger@oracle < SELECT TABLESPACE_NAME,
TABLESPACE_SIZE/1024/1024/1024 as "TABLESPACE_SIZE(G)",
ALLOCATED_SPACE/1024/1024/1024  as "ALLOCATED_SPACE (G)",
FREE_SPACE/1024/1024/1024 as "FREE_SPACE(G)"
 from DBA_TEMP_FREE_SPACE
exit
EOF>>  /home/oracle/TEMP_FREE_SPACE_CHECK.txt