REM run_2.0.1.bat version 2.0.1REM *************** 1. 基本 表,索引,触发器等 ***************
sqlplus twcity/1@ora88 @..\base\SystemTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\Chemical_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\ImportantUnits_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\LogTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\InfoTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\CtiTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\FaxTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\GISTables_2.0.2.sqlsqlplus twcity/1@ora88 @..\base3T\DutyTables_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\base3T\Sms_Three_2.0.0.sqlsqlplus twcity/1@ora88 @..\base\BaseBusinessTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base3T\BaseBusinessTables_Three_2.0.2.sql-- 20080701增加
sqlplus twcity/1@ora88 @..\base\Director_2.0.0.sqlREM ************** 2. 报表基础 **************
sqlplus twcity/1@ora88 @..\base\BaseReportTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\others_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\functions_2.0.0.sql
sqlplus twcity/1@ora88 @..\base3T\Views_Three_2.0.0.sql
REM ************ 3 . 通用初始基础数据 ***************
REM 所有insert语句,确认里面没有&符号,如果有,sql文件的开始请加上set define off;sqlplus twcity/1@ora88 @..\data\HM_ROLE_2.0.1.sql
sqlplus twcity/1@ora88 @..\data\HM_USER_2.0.0.sql
sqlplus twcity/1@ora88 @..\data\HM_ROLEUSERLINK_2.0.0.sqlsqlplus twcity/1@ora88 @..\data3T\HM_MENU1_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_MENU2_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_PLATFORMMENU_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_RIGHTS1_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_RIGHTS2_Three_2.0.0.sqlsqlplus twcity/1@ora88 @..\data\HM_ROLERIGHTLINK_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_ROLERIGHTLINK_Three_2.0.1.sqlsqlplus twcity/1@ora88 @..\data3T\DICT_DICTIONARYLIST_Three_2.0.2.sql
sqlplus twcity/1@ora88 @..\data3T\DICT_DICTIONARYTITLE_Three_2.0.2.sqlREM sqlplus twcity/1@ora88 @..\data3T\WI_MAPPING_RECORDS_Three_2.0.0.sqlREM ************ 化学危险品数据 ***************
imp twcity/1@ora88 file=..\data\danger_2.0.0.dmp tables=(CD_CHEMDANGER) fromuser=danger touser=twcity ignore=true log=impdanger.log
sqlplus twcity/1@ora88 @..\data\CD_DangerProperty_2.0.0.sql
sqlplus twcity/1@ora88 @..\data\Chem_DICT_DictionaryList_2.0.0.sqlREM ************ 4. 项目专区 ***************
REM ************ 1) 专用表等 ***************
sqlplus twcity/1@ora88 @UpdateVersion_2.0.4.sqlREM *********** 2) 报表 ******************
REM sqlplus twcity/1@ora88 @report\TempTables_2.0.0.sql
REM sqlplus twcity/1@ora88 @report\REPORT_2.0.0.pck
REM sqlplus twcity/1@ora88 @report\ReportData_2.0.0.sql
=========== 给这样一个文本要求用sql puls工具在刚装的oracle 服务端进行导库,请给出答案,本人未接触过puls请,说明详细。要求复制即可执行,谢达人|!~
sqlplus twcity/1@ora88 @..\base\SystemTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\Chemical_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\ImportantUnits_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\LogTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\InfoTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\CtiTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base\FaxTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\GISTables_2.0.2.sqlsqlplus twcity/1@ora88 @..\base3T\DutyTables_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\base3T\Sms_Three_2.0.0.sqlsqlplus twcity/1@ora88 @..\base\BaseBusinessTables_2.0.1.sql
sqlplus twcity/1@ora88 @..\base3T\BaseBusinessTables_Three_2.0.2.sql-- 20080701增加
sqlplus twcity/1@ora88 @..\base\Director_2.0.0.sqlREM ************** 2. 报表基础 **************
sqlplus twcity/1@ora88 @..\base\BaseReportTables_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\others_2.0.0.sql
sqlplus twcity/1@ora88 @..\base\functions_2.0.0.sql
sqlplus twcity/1@ora88 @..\base3T\Views_Three_2.0.0.sql
REM ************ 3 . 通用初始基础数据 ***************
REM 所有insert语句,确认里面没有&符号,如果有,sql文件的开始请加上set define off;sqlplus twcity/1@ora88 @..\data\HM_ROLE_2.0.1.sql
sqlplus twcity/1@ora88 @..\data\HM_USER_2.0.0.sql
sqlplus twcity/1@ora88 @..\data\HM_ROLEUSERLINK_2.0.0.sqlsqlplus twcity/1@ora88 @..\data3T\HM_MENU1_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_MENU2_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_PLATFORMMENU_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_RIGHTS1_Three_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_RIGHTS2_Three_2.0.0.sqlsqlplus twcity/1@ora88 @..\data\HM_ROLERIGHTLINK_2.0.0.sql
sqlplus twcity/1@ora88 @..\data3T\HM_ROLERIGHTLINK_Three_2.0.1.sqlsqlplus twcity/1@ora88 @..\data3T\DICT_DICTIONARYLIST_Three_2.0.2.sql
sqlplus twcity/1@ora88 @..\data3T\DICT_DICTIONARYTITLE_Three_2.0.2.sqlREM sqlplus twcity/1@ora88 @..\data3T\WI_MAPPING_RECORDS_Three_2.0.0.sqlREM ************ 化学危险品数据 ***************
imp twcity/1@ora88 file=..\data\danger_2.0.0.dmp tables=(CD_CHEMDANGER) fromuser=danger touser=twcity ignore=true log=impdanger.log
sqlplus twcity/1@ora88 @..\data\CD_DangerProperty_2.0.0.sql
sqlplus twcity/1@ora88 @..\data\Chem_DICT_DictionaryList_2.0.0.sqlREM ************ 4. 项目专区 ***************
REM ************ 1) 专用表等 ***************
sqlplus twcity/1@ora88 @UpdateVersion_2.0.4.sqlREM *********** 2) 报表 ******************
REM sqlplus twcity/1@ora88 @report\TempTables_2.0.0.sql
REM sqlplus twcity/1@ora88 @report\REPORT_2.0.0.pck
REM sqlplus twcity/1@ora88 @report\ReportData_2.0.0.sql
=========== 给这样一个文本要求用sql puls工具在刚装的oracle 服务端进行导库,请给出答案,本人未接触过puls请,说明详细。要求复制即可执行,谢达人|!~
sql > report\REPORT_2.0.0.pck
..........
以此类推,复制执行
twcity/1@ora88 twcity--用名名 1--密码 @ora88 这个是tns_name,你要用netca配置的
@..\data\HM_ROLE_2.0.1.sql 这个是sql脚本整个就是:调用sqlplus, 以twcity/1登录到ora88, 执行指定的那个脚本