@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 ----------------------------------------------------------------------
echo [!] Import done. See log file for errors and additional information.
echo ----------------------------------------------------------------------
echo.
set /p temp=Press ENTER to continue...
echo.

SQL*Plus: Release 8.1.7.0.0 - Production on Втн Авг 14 11:02:59 2007

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production


User dropped.

create user DB_ARH identified by 1
                                 *
ERROR at line 1:
ORA-00988: missing or invalid password(s)


grant connect, resource to DB_ARH
                           *
ERROR at line 1:
ORA-01917: user or role 'DB_ARH' does not exist


grant unlimited tablespace to DB_ARH
                              *
ERROR at line 1:
ORA-01917: user or role 'DB_ARH' does not exist


alter user DB_ARH default tablespace USERS
           *
ERROR at line 1:
ORA-01918: user 'DB_ARH' does not exist


Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production