
14.08.2007, 10:18
|
|
Познающий
Регистрация: 08.09.2005
Сообщений: 38
Провел на форуме: 324316
Репутация:
44
|
|
вот лог
Код:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername:
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 file created by EXPORT:V08.01.07 via conventional path
Warning: the objects were exported by DB_ARH, not by you
import done in CL8MSWIN1251 character set and CL8MSWIN1251 NCHAR character set
. importing DB_ARH's objects into DB_ARH
IMP-00017: following statement failed with ORACLE error 1435:
"ALTER SCHEMA = "DB_ARH""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
далее строчки повторяются дофига раз
Import terminated successfully with warnings.
вот сам батник
Код:
@echo off
cls
echo.
echo ----------------------------------------------------------------------
echo Copyright (C): 2007, DaMaGeLaB, groundhog mailto:groundhog@cccp.su
echo Special realize for MegaZLO
echo ----------------------------------------------------------------------
echo.
echo Today is [%date%]
echo.
echo Ready to import schema 'DB_ARH'. Schema 'DB_ARH' about to be dropped...
set /p temp=Press ENTER to continue or CTRL+C to exit...
echo.
echo Recreating schema 'DB_ARH'...
@sqlplus sys/change_on_install@rtidb @recreate_schema.sql >> db_arh_import.log
echo.
echo Ready to import data to schema 'DB_ARH'...
set /p temp=Press ENTER to continue or CTRL+C to exit...
echo.
echo Importing data to schema 'DB_ARH'...
@imp userid=db_arh/1@rtidb file=db_arh.dmp fromuser=db_arh touser=db_arh log=db_arh_import.log
echo.
echo ----------------------------------------------------------------------
echo [!] Import done. See log file for errors and additional information.
echo ----------------------------------------------------------------------
echo.
set /p temp=Press ENTER to continue...
echo.
может мне кажется все дело в запросах из фаиила recreate_schema.sql
как вариант запихать в него это
Код:
DROP USER db_arh;
CREATE USER db_arh IDENTIFIED BY "1"
DEFAULT TABLESPACE USERS
QUOTA UNLIMITED ON USERS QUOTA UNLIMITED ON TEMP;
GRANT CREATE ANY TABLE TO db_arh;
GRANT DELETE ANY TABLE TO db_arh;
GRANT DROP ANY TABLE TO db_arh;
GRANT INSERT ANY TABLE TO db_arh;
GRANT SELECT ANY SEQUENCE TO db_arh;
GRANT SELECT ANY TABLE TO db_arh;
GRANT UNLIMITED TABLESPACE TO db_arh;
GRANT UPDATE ANY TABLE TO db_arh;
GRANT "DBA" TO db_arh;
GRANT "CONNECT" TO db_arh;
GRANT "JAVA_ADMIN" TO db_arh;
GRANT "JAVADEBUGPRIV" TO db_arh;
GRANT "JAVA_DEPLOY" TO db_arh;
GRANT "JAVAIDPRIV" TO db_arh;
GRANT "JAVASYSPRIV" TO db_arh;
GRANT "JAVAUSERPRIV" TO db_arh;
как думаете?
|
|
|