1. Экспорт (например из 8i) exp sys/qqq@<имя БД> full=y file=c:\<Имя файла дампа>.dmp log=c:\<Имя файла лога>.log пример: exp sys/qqq@demo full=y file=c:\demo.dmp log=c:\demo_exp.log 2. Импорт далается в пустую (не инициализированную Генератором БД СМ2000)базу оракл (например в 9i). imp sys/qqq@<имя БД> full=y file=c:\<Имя файла дампа>.dmp log=c:\<Имя файла лога>.log пример: imp sys/qqq@demo full=y file=c:\demo.dmp log=c:\demo_imp.log imp sys/qqq@kvartco full=y file=c:\kvartco.dmp log=c:\kvartco_imp.log 3. Сразу же после импорта, из серверного SQLPLUS и под sys'ом !!! : в 9i GRANT SELECT ON SYS.DBA_JOBS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_ROLES TO SUPERMAG; GRANT SELECT ON SYS.DBA_USERS TO SUPERMAG WITH GRANT OPTION; GRANT EXECUTE ON SYS.DBMS_ALERT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_LOCK TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_PIPE TO SUPERMAG; GRANT SELECT ON SYS.V_$SESSION TO SUPERMAG; в 10G GRANT SELECT ON SYS.DBA_JOBS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_ROLES TO SUPERMAG; GRANT SELECT ON SYS.DBA_USERS TO SUPERMAG WITH GRANT OPTION; GRANT EXECUTE ON SYS.DBMS_ALERT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_LOCK TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_PIPE TO SUPERMAG; GRANT SELECT ON SYS.V_$SESSION TO SUPERMAG; grant select on SYS.DBA_CONSTRAINTS to supermag with grant option; grant select on SYS.DBA_TAB_COLUMNS to supermag with grant option; grant select on SYS.DBA_CONS_COLUMNS to supermag with grant option; GRANT SELECT ANY TABLE TO SUPERMAG; grant select on dba_users to public; в 11G GRANT ADMINISTER DATABASE TRIGGER TO SUPERMAG; GRANT ALTER ANY ROLE TO SUPERMAG; GRANT ALTER USER TO SUPERMAG WITH ADMIN OPTION; GRANT ANALYZE ANY TO SUPERMAG; GRANT CREATE DATABASE LINK TO SUPERMAG; GRANT CREATE LIBRARY TO SUPERMAG; GRANT CREATE PUBLIC SYNONYM TO SUPERMAG; GRANT CREATE ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT CREATE SNAPSHOT TO SUPERMAG; GRANT CREATE TABLE TO SUPERMAG; GRANT CREATE USER TO SUPERMAG WITH ADMIN OPTION; GRANT DROP ANY ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT DROP PUBLIC SYNONYM TO SUPERMAG; GRANT DROP USER TO SUPERMAG WITH ADMIN OPTION; GRANT GRANT ANY ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT SELECT ON SYS.DBA_CONS_COLUMNS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_CONSTRAINTS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_JOBS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_ROLES TO SUPERMAG; GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_USERS TO SUPERMAG WITH GRANT OPTION; GRANT EXECUTE ON SYS.DBMS_ALERT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_LOCK TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_OUTPUT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_PIPE TO SUPERMAG; GRANT SELECT ON SYS.V_$SESSION TO SUPERMAG; GRANT SELECT ON SYS.V_$INSTANCE TO SUPERMAG; ********************** добавляю от себя: этого оказалось мало, так как генератор потом выдаст ошибку нужны еще гранты следующие: GRANT ADMINISTER DATABASE TRIGGER TO SUPERMAG; GRANT ALTER ANY ROLE TO SUPERMAG; GRANT ALTER USER TO SUPERMAG WITH ADMIN OPTION; GRANT ANALYZE ANY TO SUPERMAG; GRANT CREATE DATABASE LINK TO SUPERMAG; GRANT CREATE LIBRARY TO SUPERMAG; GRANT CREATE PUBLIC SYNONYM TO SUPERMAG; GRANT CREATE ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT CREATE SNAPSHOT TO SUPERMAG; GRANT CREATE TABLE TO SUPERMAG; GRANT CREATE USER TO SUPERMAG WITH ADMIN OPTION; GRANT DROP ANY ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT DROP PUBLIC SYNONYM TO SUPERMAG; GRANT DROP USER TO SUPERMAG WITH ADMIN OPTION; GRANT GRANT ANY ROLE TO SUPERMAG WITH ADMIN OPTION; GRANT SELECT ON SYS.DBA_CONS_COLUMNS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_CONSTRAINTS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_JOBS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_ROLES TO SUPERMAG; GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO SUPERMAG WITH GRANT OPTION; GRANT SELECT ON SYS.DBA_USERS TO SUPERMAG WITH GRANT OPTION; GRANT EXECUTE ON SYS.DBMS_ALERT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_LOCK TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_OUTPUT TO SUPERMAG; GRANT EXECUTE ON SYS.DBMS_PIPE TO SUPERMAG; GRANT SELECT ON SYS.V_$SESSION TO SUPERMAG; GRANT SELECT ON SYS.V_$INSTANCE TO SUPERMAG; WHENEVER SQLERROR EXIT 1 ROLLBACK; WHENEVER OSERROR EXIT 2 ROLLBACK; grant SUPERMAG_ADMIN to SUPERMAG; grant SUPERMAG_USER to SUPERMAG; alter user SUPERMAG default role SUPERMAG_ADMIN, SUPERMAG_USER; grant select on V_$SESSION to SUPERMAG with grant option; grant select on V_$INSTANCE to SUPERMAG; grant execute on DBMS_ALERT to SUPERMAG; grant execute on DBMS_PIPE to SUPERMAG; grant select on DBA_USERS to SUPERMAG with grant option; grant select on DBA_ROLES to SUPERMAG; grant select on dba_constraints to SUPERMAG with grant option; grant select on dba_tab_columns to SUPERMAG with grant option; grant select on dba_cons_columns to SUPERMAG with grant option; grant create role to SUPERMAG; grant alter any role to SUPERMAG; grant create library to SUPERMAG; grant create public synonym to SUPERMAG; grant drop public synonym to SUPERMAG; grant administer database trigger to SUPERMAG; grant execute on DBMS_LOCK to SUPERMAG; grant execute on DBMS_UTILITY to SUPERMAG with grant option; grant select on dba_jobs to SUPERMAG with grant option; grant create database link to SUPERMAG; grant create snapshot to SUPERMAG; grant create table to SUPERMAG; grant ANALYZE ANY to SUPERMAG; grant create any index to SUPERMAG; grant drop any index to SUPERMAG; grant global query rewrite to SUPERMAG; grant alter system to SUPERMAG; grant create user to SUPERMAG with admin option; grant alter user to SUPERMAG with admin option; grant drop user to SUPERMAG with admin option; grant create role to SUPERMAG with admin option; grant drop any role to SUPERMAG with admin option; grant grant any role to SUPERMAG with admin option; COMMIT; **************************************************************** 4. Перекомпиляция процедур запустить из серверного sqlplus с рабочей папкой %ORACLE_HOME%\RDBMS\ADMIN\ @utlrp.sql; @D:\Oracle\Ora11.2.0\RDBMS\ADMIN\utlrp.sql; Запускать несколько раз пока warning`ов не станет 0. Если остались warning`и то с ними нужно разобраться отдельно. выглядеть будет примерно так: OBJECTS WITH ERRORS ------------------- 0 5. Запустить "Генератор БД" нужной версии, если версия не меняется, то этой же версии. 6. Если версия с сервис паком, то "прогнать" скрипты сервис пака. ***************************** ВСЕ!!! у меня все получилось гладко, согласно вышеизложенной инструкции преход с 9ки на 1 состояся Слюсаренко Евгений Квартал, Великий новгород P.S. экспорт схемы supermag exp sys/qqq@demo owner=supermag file=c:\demo.dmp log=c:\demo_exp.log imp sys/qqq@demo2 fromuser=supermag touser=supermag ignore=y commit=y file=c:\demo.dmp log=c:\demo_imp.log экспорт определенной таблицы exp sys/qqq@demo file=c:\smspec.dmp owner=supermag tables=smspec consistent=Y|N log=c:\smspec_exp.log imp sys/qqq@demo file=c:\smspec.dmp touser=supermag ignore=y tables=smspec log=c:\smspec_imp.log