error during import dmp....
hi,
I did these steps:
CREATE TABLESPACE AFM_P1 DATAFILE 'c:\....\AFM_P01.dbf' SIZE 1700M EXTENT MANAGEMENT LOCAL UNIFORM;
CREATE USER AFM_SECURE IDENTIFIED BY AFM DEFAULT TABLESPACE AFM_P1 TEMPORARY TABLESPACE TEMP;
CREATE USER AFM IDENTIFIED BY AFM DEFAULT TABLESPACE AFM_P1 TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE SYNONYM TO AFM;
GRANT CONNECT, RESOURCE TO AFM_SECURE;
imp system/manager@mydb fromuser=afm_secure touser=afm_secure file=C:\...\mydump.dmp log=C:\..\mylog.log
BUT I GET THESE ERRORS:
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8DEC character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing AFM_SECURE's objects into AFM_SECURE
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'AFM_SECURE', export_db"
"_name=>'CENTOS.US.ORACLE.COM', inst_scn=>'809152');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "AFM_GROUPS" ("GROUP_NAME" VARCHAR2(10) NOT NULL ENABLE, "GROU"
"P_TITLE" VARCHAR2(128), "WW_PREFERENCES" VARCHAR2(2000)) PCTFREE 10 PCTUSE"
"D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FREELIST GRO"
"UPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "AFM_USERS" ("USER_NAME" VARCHAR2(32) NOT NULL ENABLE, "GROUP_"
"1" VARCHAR2(10), "GROUP_10" VARCHAR2(10), "GROUP_2" VARCHAR2(10), "GROUP_3""
" VARCHAR2(10), "GROUP_4" VARCHAR2(10), "GROUP_5" VARCHAR2(10), "GROUP_6" VA"
"RCHAR2(10), "GROUP_7" VARCHAR2(10), "GROUP_8" VARCHAR2(10), "GROUP_9" VARCH"
"AR2(10), "USER_LEVEL" NUMBER(*,0), "USER_PWD" VARCHAR2(10)) PCTFREE 10 PCT"
"USED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FREELIST "
"GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00008: unrecognized statement in the export file:
yýu
IMP-00008: unrecognized statement in the export file:
R
IMP-00008: unrecognized statement in the export file:
What I wrong? or dmp file is corrupted??
Thanks
Raf