Import

[dandansilver 0]

Estou com problemas de import, ao importer a base de dados de produção sendo que e Oracle 9.2.0.4 para base de dados de Desenvolvimento que e a mesmo Oracle 9.2.0.4 ....sendo que esta maquina foi instalado o patch ontem, esta dando a seguinte mensagem de erro abaixo :Se poder me ajudar agradeçoC:\Temp>imp Import: Release 9.2.0.4.0 - Production on Mon Feb 20 21:07:31 2006 Copyright © 1982, 2002, Oracle Corporation. All rights reserved. Username: oracle_backupPassword: Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - Production Import file: EXPDAT.DMP > expfull1.dmp Enter insert buffer size (minimum is 8192) 30720> 30720 Export file created by EXPORT:V09.02.00 via conventional pathimport done in WE8MSWIN1252 character set and UTF8 NCHAR character setimport server uses WE8ISO8859P1 character set (possible charset conversion)List contents of import file only (yes/no): no > Ignore create error due to object existence (yes/no): no > Import grants (yes/no): yes > Import table data (yes/no): yes > n Import entire export file (yes/no): no > y . importing SYSTEM's objects into SYSTEMIMP-00015: following statement failed because the object already exists: "CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADA" "TA\ALFA\UNDOTBS.DBF' SIZE 623902720 AUTOEXTEND ON NEXT 5242880 MAXSI" "ZE 32767M EXTENT MANAGEMENT LOCAL "IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "INDX" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\I" "NDX.DBF' SIZE 52428800 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M EXT" "ENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPA" "CE MANAGEMENT AUTO"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TOOLS" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TOOLS.DBF' SIZE 52428800 AUTOEXTEND ON NEXT 327680 MAXSIZE 32767M EX" "TENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SP" "ACE MANAGEMENT AUTO"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "USERS.DBF' SIZE 52428800 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M E" "XTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT S" "PACE MANAGEMENT AUTO"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDSW" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDSW.DBF' SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSISW" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSISW.DBF' SIZE 104857600 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDSC" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDSC.DBF' SIZE 838860800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSISC" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSISC.DBF' SIZE 314572800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDBO" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDBO.DBF' SIZE 1500M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE P" "ERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSIBO" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSIBO.DBF' SIZE 1048576000 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONL" "INE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDCC" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDCC.DBF' SIZE 2000M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE P" "ERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSICC" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSICC.DBF' SIZE 1050M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE P" "ERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDCV" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDCV.DBF' SIZE 524288000 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSICV" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSICV.DBF' SIZE 838860800 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI" "NE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDHB" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDHB.DBF' SIZE 1200M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE P" "ERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDCF" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSDCF.DBF' SIZE 838860800 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20480" "0 ONLINE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSICF" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA\" "TSICF.DBF' SIZE 524288000 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20480" "0 ONLINE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDOMF" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA" "\TSDOMF.DBF' SIZE 576716800 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 204" "800 ONLINE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSIOMF" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA" "\TSIOMF.DBF' SIZE 524288000 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 204" "800 ONLINE PERMANENT NOLOGGING"IMP-00015: following statement failed because the object already exists: "CREATE TEMPORARY TABLESPACE "TEMP_NEW" BLOCKSIZE 8192 TEMPFILE 'E:\ORACLE\" "ORADATA\ALFA\TEMP_NEW.DBF' SIZE 3434M AUTOEXTEND ON NEXT 1048576 MAX" "SIZE 5000M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "TSDSLF" BLOCKSIZE 8192 DATAFILE 'E:\ORACLE\ORADATA\ALFA" "\TSDSLF.DBF' SIZE 2097152 AUTOEXTEND ON NEXT 131072 MAXSIZE 32767M E" "XTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT "IMP-00015: following statement failed because the object already exists: "CREATE USER "OUTLN" IDENTIFIED BY VALUES '70B091132067B86C' TEMPORARY TABLE" "SPACE "TEMP_NEW" PASSWORD EXPIRE"IMP-00015: following statement failed because the object already exists: "CREATE USER "WMSYS" IDENTIFIED BY VALUES 'AD8AF0D8290CBB34' TEMPORARY TABLE" "SPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "ADMINISTRATOR" IDENTIFIED BY VALUES '77032331473CE190' TEMPORA" "RY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "SINCORR" IDENTIFIED BY VALUES 'CACA4FF63C3459E3' DEFAULT TABLE" "SPACE "TSICV" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "SINACOR" IDENTIFIED BY VALUES 'C2EFF09D90809CAE' DEFAULT TABLE" "SPACE "TSICV" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "SINAWIN" IDENTIFIED BY VALUES '99CB1B119B1186F0' DEFAULT TABLE" "SPACE "TSICV" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "CORRWIN" IDENTIFIED BY VALUES '5FBEDCA023984F0A' DEFAULT TABLE" "SPACE "TSICV" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "HOME" IDENTIFIED BY VALUES '7298E6BBFFAF8318' DEFAULT TABLESPA" "CE "TSDHB" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "NAMES" IDENTIFIED BY VALUES '64F00235304476CA' TEMPORARY TABLE" "SPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE USER "IUSR_IS" IDENTIFIED BY VALUES 'D0E4D75BA12DDABC' DEFAULT TABLE" "SPACE "TSDSLF" TEMPORARY TABLESPACE "TEMP_NEW""IMP-00015: following statement failed because the object already exists: "CREATE ROLE "SELECT_CATALOG_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "SELECT_CATALOG_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "EXECUTE_CATALOG_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "EXECUTE_CATALOG_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "DELETE_CATALOG_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "DELETE_CATALOG_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "RECOVERY_CATALOG_OWNER""IMP-00015: following statement failed because the object already exists: "REVOKE "RECOVERY_CATALOG_OWNER" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "GATHER_SYSTEM_STATISTICS""IMP-00015: following statement failed because the object already exists: "REVOKE "GATHER_SYSTEM_STATISTICS" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "LOGSTDBY_ADMINISTRATOR""IMP-00015: following statement failed because the object already exists: "REVOKE "LOGSTDBY_ADMINISTRATOR" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "AQ_ADMINISTRATOR_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "AQ_ADMINISTRATOR_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "AQ_USER_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "AQ_USER_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY "IMP-00015: following statement failed because the object already exists: "CREATE ROLE "HS_ADMIN_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "HS_ADMIN_ROLE" FROM SYSTEM"IMP-00015: following statement failed because the object already exists: "CREATE ROLE "WM_ADMIN_ROLE""IMP-00015: following statement failed because the object already exists: "REVOKE "WM_ADMIN_ROLE" FROM SYSTEM"IMP-00017: following statement failed with ORACLE error 3113: "BEGIN " "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO" "N_CONTEXT_OBJ, 'SYS',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO" "N_CONTEXT_OBJ, 'DBA',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_EVALUATIO" "N_CONTEXT_OBJ, 'AQ_ADMINISTRATOR_ROLE',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU" "ATION_CONTEXT, 'SYS',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.CREATE_ANY_EVALU" "ATION_CONTEXT, 'DBA',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA" "TION_CONTEXT, 'SYS',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.ALTER_ANY_EVALUA" "TION_CONTEXT, 'DBA',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT" "ION_CONTEXT, 'SYS',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.DROP_ANY_EVALUAT" "ION_CONTEXT, 'DBA',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL" "UATION_CONTEXT, 'SYS',TRUE);" "" "SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVAL" "UATION_CONTEXT, 'DBA',TRUE);" "" "COMMIT; END;"IMP-00003: ORACLE error 3113 encounteredORA-03113: end-of-file on communication channelIMP-00003: ORACLE error 3114 encounteredORA-03114: not connected to ORACLE

[alphamek 2]

Daniel, Tente fazer assim: imp oracle_backup file=expfull1.dmp log=expfull1.log fromuser=OWNER touser=NOVO_OWNER ignore=y Veja os resultados e poste aqui. Abraços, :lol: