install.sql

胸外科信息管理系统.rar(powerbuilder)

document
DISCREPTION:    this batch file is the installation file
		of the application database of the HLIS
		in the server.
USAGE:          perform the following command in the
		sqlplus's prompt:
		start install
AUTHOR:		gao yi
CREATION DATE:	2002-01-01
LAST UPDATE:	2002-01-01
#

remark pathname example : c:\srvinst
remark datefile example (windows 98, Oracle 7.3) : c:\ORAWIN95\database
	
remark accept pathname char prompt '安装文件路径名：  '
remark accept datafile char prompt '数据文件路径名：  '
define srvname = 'dbserver'
define pathname = 'c:\srvinst'
define datafile = 'C:\ORAWIN95\database'

spool &pathname\log\install1.log

prompt ************************************************
prompt *     HIS Application Database Installation    *
prompt ************************************************
prompt
prompt The logfile of the installation is :
prompt  &pathname\install.log
prompt The name of the server is :
prompt          &srvname

set heading off
select 'Today is : ',to_char(sysdate,'yyyy-mm-dd') from dual;
prompt
select 'The start time is : ',to_char(sysdate,'hh24:mi:ss') from dual;
prompt 
prompt Let's begin ......
prompt
prompt ************************************************
prompt *       Creation of Application Database       *
prompt ************************************************
prompt
start &pathname\install\install
prompt
select 'The finished time is : ',to_char(sysdate,'hh24:mi:ss') from dual;
set heading on

spool off
exit;