Boa tarde, Estou com um problema na importação de um damping. Toda a noite eu faço um export do banco. Mas para minha surpresa, fui fazer o processo de importar em uma base de teste e deu erro.
Segue o erro abaixo para avaliação. Abraços Alex dos Santos **************************************************** exp root/[EMAIL PROTECTED] file=/Backup/oracle/full.dmp log=/home/oracle/sql/full_exp.log full=y consistent=y scrip para o export *************************************************** imp system/[EMAIL PROTECTED] FILE=/home/oracle/sql/full.dmp FULL=YES IGNORE=YES LOG=/home/oracle/sql/full.log script para o import *************************************************** Erro no import ORA-01918: user 'QS' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "QS_WS" QUOTA UNLIMITED ON "EXAMPLE"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'QS_WS' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "QS_ES" QUOTA UNLIMITED ON "EXAMPLE"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'QS_ES' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "QS_OS" QUOTA UNLIMITED ON "EXAMPLE"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'QS_OS' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "QS_CBADM" QUOTA UNLIMITED ON "EXAMPLE"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'QS_CBADM' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "QS_CS" QUOTA UNLIMITED ON "EXAMPLE"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'QS_CS' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "RMAN" QUOTA UNLIMITED ON "TOOLS"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'RMAN' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "BRUHN" QUOTA UNLIMITED ON "CPERSDADOS" QUOTA UNLIMITED ON "CPER" "SINDEX"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'BRUHN' does not exist IMP-00017: following statement failed with ORACLE error 1918: "ALTER USER "ROOT" QUOTA UNLIMITED ON "CPERSDADOS" QUOTA UNLIMITED ON "CPERS" "INDEX"" IMP-00003: ORACLE error 1918 encountered ORA-01918: user 'ROOT' does not exist . importing WMSYS's objects into WMSYS . importing WKSYS's objects into WKSYS "ALTER SESSION SET CURRENT_SCHEMA= "WKSYS"" IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-00000: Import terminated unsuccessfully [As partes desta mensagem que não continham texto foram removidas] Sábado Agora: ENPO-BR 2006 - Encontro Nacional de Profissionais Oracle VISITE: http://www.enpo-br.org/ - Dia 11/11 "Vagas Limitadas" ________________________________________________________________ Este Grupo recebe o apoio da SQL Magazine - www.devmedia.com.br/sqlmagazine -------------------------------------------------------------------------------------------------------------------------- Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ -------------------------------------------------------------------------------------------------------------------------- O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: http://www.oraclebr.com.br/ ------------------------------------------------------------------------------------------------------------------------ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: [EMAIL PROTECTED] <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html