мда чето не сложилось,
вобщем мои ход действий таков,
сделал экспорт с главного сервера,
Код:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in CL8MSWIN1251 character set and CL8MSWIN1251 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DB_ARH
. exporting object type definitions for user DB_ARH
About to export DB_ARH's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export DB_ARH's tables via Conventional Path ...
. . exporting table ADD_FIELD_DATA 0 rows exported
. . exporting table ADD_FIELD_LIST 0 rows exported
. . exporting table AFFILIATE 0 rows exported
. . exporting table APPLY 6700 rows exported
. . exporting table APPLY_INV 94 rows exported
. . exporting table A_CONTROL 0 rows exported
. . exporting table A_DATA_SOURCE 6 rows exported
. . exporting table A_FIELD 1450 rows exported
. . exporting table A_JOB 0 rows exported
. . exporting table A_JOB_STATUS 0 rows exported
. . exporting table A_LOG 1076 rows exported
. . exporting table A_MODIFY_LOG 1757 rows exported
. . exporting table A_PROFILE 732 rows exported
. . exporting table A_SCRIPT 0 rows exported
. . exporting table A_SCRIPT_BODY 0 rows exported
. . exporting table A_SERVER_INSTANCE 1 rows exported
. . exporting table A_TABLE 57 rows exported
. . exporting table A_TABLE_SEQ 61 rows exported
. . exporting table A_VERSION 1 rows exported
. . exporting table BANK 4499 rows exported
. . exporting table BILL 12 rows exported
. . exporting table BRUNCH_RTI 91 rows exported
. . exporting table BSO_LCARD 4259 rows exported
. . exporting table BSO_LIC 149 rows exported
. . exporting table CAR 14681 rows exported
. . exporting table DOC 691 rows exported
. . exporting table DOC_BODY 1472 rows exported
. . exporting table DOC_BODY_ARCHIVE 0 rows exported
. . exporting table DOC_BOOKMARK 0 rows exported
. . exporting table DOC_CELL 0 rows exported
. . exporting table DOC_ITEM 1553 rows exported
. . exporting table DOC_MODEL 109 rows exported
. . exporting table DUPLICATE 0 rows exported
. . exporting table HISTORY_LCARD 49305 rows exported
. . exporting table HISTORY_LIC 12318 rows exported
. . exporting table H_APPLY_TYPE 12 rows exported
. . exporting table H_CAR_TYPE 35 rows exported
. . exporting table H_DOC_ITEM_TYPE 12 rows exported
. . exporting table H_FS 33 rows exported
. . exporting table H_INV_DOC 30 rows exported
. . exporting table H_LEVEL 14 rows exported
. . exporting table H_LIC_ACTIVITY 22 rows exported
. . exporting table H_LINK_APPLY_ACTIV 51 rows exported
. . exporting table H_LINK_APPLY_TOVAR 18 rows exported
. . exporting table H_OKVED 1 rows exported
. . exporting table H_OPF 39 rows exported
. . exporting table H_PERSONAL_CATEGORY 14 rows exported
. . exporting table H_PRIVELEGES 6 rows exported
. . exporting table H_STATUS 17 rows exported
. . exporting table H_TOVAR 10 rows exported
. . exporting table LCARD 25836 rows exported
. . exporting table LIC 6480 rows exported
. . exporting table LINK_APPLY_DOC 625 rows exported
. . exporting table LINK_APPLY_LCARD 667 rows exported
. . exporting table LINK_LIC_ACTIV_CAR 10441 rows exported
. . exporting table LINK_TABLE_FIELD 0 rows exported
. . exporting table LINK_USERS_ORG_UNIT 0 rows exported
. . exporting table LINK_USER_CONTROL 0 rows exported
. . exporting table MESSAGE 10 rows exported
. . exporting table MODEL_ITEM 828 rows exported
. . exporting table ORG_UNIT 2869 rows exported
. . exporting table PLANT 5756 rows exported
. . exporting table PLANT_CAR 14679 rows exported
. . exporting table PLANT_PERSON 147 rows exported
. . exporting table PLANT_TEMP 11394 rows exported
. . exporting table ROAD_EVENTS 108 rows exported
. . exporting table SCHET 112 rows exported
. . exporting table SCHET_DETAIL 219 rows exported
. . exporting table SERVER_LIST 0 rows exported
. . exporting table SQL_SCRIPT 0 rows exported
. . exporting table USERS 27 rows exported
. . exporting table USER_ACCESS 0 rows exported
. . exporting table V_PLANT_DIR 1 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
Далее взял комп (тестовая машина) на которой стояла база месячной давности и залил туда дамп через import.cmd
Код:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully
как видно из лога он ругается на пользователя, как результат база пустая и пользователей нет.
дальше воспользовался своим батником (из первого поста) для импорта базы и все стало ок =)
кстати как вариант у меня сеичас идея хоть и глупая и ламерская до безобразия но она работает,
сначало запускаю import.cmd он бахает все а потом запускаю батник из первого поста и вуаля все готова =)
P.s. это не вариант а временное решение =)
тут лежат логи
http://slil.ru/24731693