Home » SQL & PL/SQL » SQL & PL/SQL » How to import DUMP file to a new database?
|
|
|
|
|
|
|
|
|
Re: How to import DUMP file to a new database? [message #209371 is a reply to message #209367] |
Thu, 14 December 2006 08:05 |
braimi
Messages: 18 Registered: December 2006 Location: Muscat
|
Junior Member |
|
|
Hi taj
i ran the imp command and heres the error messages i returned
Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V07.03.04 via conventional path
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_RBS" DATAFILE 'C:\BROK\BRK2_RBS.DBF' SIZE 62914560 "
" DEFAULT STORAGE (INITIAL 20480 NEXT 20480 MINEXTENTS 1 MAXEXTENTS 249 "
"PCTINCREASE 50) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_TEMP" DATAFILE 'C:\BROK\BRK2_TEMP.DBF' SIZE 31457280"
" DEFAULT STORAGE (INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS"
" 249 PCTINCREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_TOOLS" DATAFILE 'C:\BROK\BRK2_TOOLS.DBF' SIZE 314572"
"80 DEFAULT STORAGE (INITIAL 53248 NEXT 53248 MINEXTENTS 1 MAXEXTENTS "
"249 PCTINCREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_01" DATAFILE 'C:\BROK\TS_01.DBF' SIZE 734003200 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_02" DATAFILE 'C:\BROK\TS_02.DBF' SIZE 125829120 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_03" DATAFILE 'C:\BROK\TS_03.DBF' SIZE 104857600 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 10615:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' DEFAULT TABLESP"
"ACE "DB_TOOLS" TEMPORARY TABLESPACE "DB_TEMP""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00015: following statement failed because the object already exists:
"CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'E066D214D5421CCC'"
IMP-00017: following statement failed with ORACLE error 10615:
"CREATE USER "ADM" IDENTIFIED BY VALUES '9061A022C3C770AD' DEFAULT TABLESPAC"
"E "TS_01" TEMPORARY TABLESPACE "DB_TEMP""
IMP-00003: ORACLE error 10615 encountered
ORA-10615: Invalid tablespace type for temporary tablespace
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ADMIN" IDENTIFIED BY VALUES '434205ADFE1B7B0E'"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "BATCH" IDENTIFIED BY VALUES 'B25772A5B2A11B84'"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "żżżżżżżżż" IDENTIFIED BY VALUES '3CD0CEC138D5B45E'"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "żżżż" IDENTIFIED BY VALUES 'E6EFB78C3004DA9C'"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "FAISAL" IDENTIFIED BY VALUES '4223CD883484E9D5' DEFAULT TABLES"
"PACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ALAA" IDENTIFIED BY VALUES '169BB1EE51D98F39' DEFAULT TABLESPA"
"CE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "HAFY" IDENTIFIED BY VALUES 'AB3BAA27B909BB5E' DEFAULT TABLESPA"
"CE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ABDULRAHMAN" IDENTIFIED BY VALUES 'ABDA52C7A1A7AF82' DEFAULT T"
"ABLESPACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "HAMAD" IDENTIFIED BY VALUES '51E76A0CFB07A891' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "YASER" IDENTIFIED BY VALUES '136CE09200159D27'"
IMP-00015: following statement failed because the object already exists:
"CREATE USER "HAMED" IDENTIFIED BY VALUES '2EC3DE9D28736E2F' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ALHAFI" IDENTIFIED BY VALUES '0FBD548DA3439832' DEFAULT TABLES"
"PACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ABDUL" IDENTIFIED BY VALUES 'CE522F6E7917CFD8' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ALAA1" IDENTIFIED BY VALUES '7D0F9AE387B415F6' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "ALA" IDENTIFIED BY VALUES 'EF38CB79D981542C' DEFAULT TABLESPAC"
"E "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "CEO" IDENTIFIED BY VALUES '1004E08011D692A7' DEFAULT TABLESPAC"
"E "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "SAHAR" IDENTIFIED BY VALUES '76DCE0EB5F552036' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "SAFIYA" IDENTIFIED BY VALUES '4535DB8F5346D1B9' DEFAULT TABLES"
"PACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE USER "MAHMOUD" IDENTIFIED BY VALUES 'BA78FDB73F42D837' DEFAULT TABLE"
"SPACE "TS_02""
IMP-00015: following statement failed because the object already exists:
"CREATE ROLE "SNMPAGENT""
IMP-00015: following statement failed because the object already exists:
"REVOKE "SNMPAGENT" FROM SYSTEM"
IMP-00015: following statement failed because the object already exists:
"CREATE ROLE "DEV""
IMP-00015: following statement failed because the object already exists:
"REVOKE "DEV" FROM SYSTEM"
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "ADM""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ADM""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ADM" DEFAULT ROLE "DEV""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT SYSTEM1 STORAGE (INITIAL 53248 NEXT 1064960 MINEXTE"
"NTS 2 MAXEXTENTS 41) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB01 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB02 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB03 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB04 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB_DEL STORAGE (INITIAL 1024000 NEXT 1024000 MINEXT"
"ENTS 2 MAXEXTENTS 121) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00015: following statement failed because the object already exists:
"CREATE PUBLIC DATABASE LINK "MARKET.WORLD" CONNECT TO "BROKER28" IDENTIFIED"
" BY "WATEN123" USING 'msmcds.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE PUBLIC DATABASE LINK "PREVIOUSYEAR.WORLD" CONNECT TO "INSIGHT" IDENT"
"IFIED BY "BROK" USING '2005.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE PUBLIC DATABASE LINK "TO_BRK.WORLD" CONNECT TO "INSIGHT" IDENTIFIED "
"BY "BROK" USING 'BRK1.WORLD'"
. importing INSIGHT's objects into INSIGHT
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "BRK1LINK.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "B"
"ROK" USING 'brk1.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "BROK1.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "BROK"
"" USING 'brk1.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "DD1.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "MSM1" "
"USING 'ROH_MSM1.WORLD'"
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "MASTER.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "BRO"
"K" USING 'MASTER.WORLD'"
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "OLD.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "BROK" "
"USING 'brk.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE DATABASE LINK "TO_BRK1.WORLD" CONNECT TO "INSIGHT" IDENTIFIED BY "BR"
"OK" USING 'brk1.world'"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "EVT_NOTIFY_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999"
"99999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "EVT_OPERATORS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "EVT_PROFILE_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999"
"999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMACTUALPARAMETERSEQUENCE" MINVALUE 1 MAXVALUE 99999999999"
"9999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMAGENTJOBSEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMARCHIVESEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMCONSOLESOSETTINGSEQUENCE" MINVALUE 1 MAXVALUE 9999999999"
"99999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMDATABASESEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMDBAUTHSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999999999"
"9999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMDEFAUTHSEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMDISTRIBUTIONSETSEQUENCE" MINVALUE 1 MAXVALUE 99999999999"
"9999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMFOLDERSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999999999"
"9999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMFORMALPARAMETERSEQUENCE" MINVALUE 1 MAXVALUE 99999999999"
"9999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMGLOBALCONFIGURATIONSEQUENCE" MINVALUE 1 MAXVALUE 9999999"
"99999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMHOSTAUTHSEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMHOSTSEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999"
"99999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMINSTALLATIONSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999"
"9999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMLOGMESSAGESEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999"
"99999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMMONTHLYENTRYSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999"
"9999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMMONTHWEEKENTRYSEQUENCE" MINVALUE 1 MAXVALUE 999999999999"
"999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMOMSTRINGSEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 41 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMPACKAGESEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMPARALLELJOBSEQUENCE" MINVALUE 1 MAXVALUE 999999999999999"
"999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMPARALLELOPERATIONSEQUENCE" MINVALUE 1 MAXVALUE 999999999"
"999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMPARALLELSTATEMENTSEQUENCE" MINVALUE 1 MAXVALUE 999999999"
"999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMPRODUCTSEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMP_JOB_ID_" MINVALUE 1 MAXVALUE 99999999 INCREMENT BY 1 S"
"TART WITH 1 CACHE 20 NOORDER CYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMP_LONG_ID" MINVALUE 1 MAXVALUE 9999999999999999999999999"
"99 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMP_SERVICE_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999"
"999999 INCREMENT BY 1 START WITH 16660 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMRELEASESEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999"
"99999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMRUNSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMSCHEDULESEQUENCE" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMSHAREDORACLECLIENTSEQUENCE" MINVALUE 1 MAXVALUE 99999999"
"9999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMSHAREDORACLECONFIGSEQUENCE" MINVALUE 1 MAXVALUE 99999999"
"9999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMTABLESPACESEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999"
"99999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMTEMPORARYSEQUENCE" MINVALUE 1 MAXVALUE 99999999999999999"
"9999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMVCENDPOINTSEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999"
"99999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "SMWEEKLYENTRYSEQUENCE" MINVALUE 1 MAXVALUE 999999999999999"
"999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "ORDER_SEQ" MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 S"
"TART WITH 140057 NOCACHE NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "A_AUTHORIZATION_SNO" MINVALUE 1 MAXVALUE 99999999999 INCRE"
"MENT BY 1 START WITH 3499 NOCACHE NOORDER CYCLE"
. importing SYSTEM's objects into SYSTEM
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "DEF$_CALL" ("DEFERRED_TRAN_DB" VARCHAR2(128), "DEFERRED_TRAN_"
"ID" VARCHAR2(22), "BUFFER_NUMBER" NUMBER, "CALLNO" NUMBER, "SCHEMANAME" VAR"
"CHAR2(30), "PACKAGENAME" VARCHAR2(30), "PROCNAME" VARCHAR2(30), "ARGCOUNT" "
"NUMBER, "PARM_BUFFER" LONG RAW, "DESTINATION_LIST" CHAR(1), "ORIGIN_USER_ID"
"" NUMBER, "ORIGIN_USER" VARCHAR2(30), "DELIVERY_ORDER" NUMBER, "ORIGIN_TRAN"
"_ID" VARCHAR2(22), "ORIGIN_TRAN_DB" VARCHAR2(128), "START_TIME" DATE, "DEST"
"INATION_COUNT" NUMBER(*,0), "COMMIT_COMMENT" VARCHAR2(50)) PCTFREE 10 PCTU"
"SED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS "
"1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) "
" "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "DEF$_CALLDEST" ("DEFERRED_TRAN_DB" VARCHAR2(128), "DEFERRED_T"
"RAN_ID" VARCHAR2(22), "CALLNO" NUMBER, "DUMMY_BUFFER_NUMBER" NUMBER DEFAULT"
" 1, "DBLINK" VARCHAR2(128)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 50"
" FREELISTS 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "DEF$_DEFAULTDEST" ("DBLINK" VARCHAR2(128)) PCTFREE 10 PCTUSE"
"D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1 "
"MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) "
" "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "DEF$_DESTINATION" ("DBLINK" VARCHAR2(128), "LAST_DELIVERED" N"
"UMBER DEFAULT 0 NOT NULL, "LAST_TRAN_ID" VARCHAR2(22), "LAST_TRAN_DB" VARC"
"HAR2(128), "DISABLED" CHAR(1), "JOB" NUMBER, "LAST_TXN_COUNT" NUMBER, "LAST"
"_ERROR" NUMBER, "LAST_MSG" VARCHAR2(2000)) PCTFREE 10 PCTUSED 40 INITRANS "
"1 MAXTRANS 255 STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1 MAXEXTENTS 249"
" PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "DEF$_ERROR" ("DEFERRED_TRAN_DB" VARCHAR2(128), "DEFERRED_TRAN"
"_ID" VARCHAR2(22), "CALLNO" NUMBER, "DESTINATION" VARCHAR2(128), "ERROR_TIM"
"E" DATE, "ERROR_NUMBER" NUMBER, "ERROR_MSG" VARCHAR2(2000)) PCTFREE 10 PCT"
"USED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS"
" 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1) "
" "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "PRODUCT_PROFILE" ("PRODUCT" VARCHAR2(30) NOT NULL, "USERID" V"
"ARCHAR2(30), "ATTRIBUTE" VARCHAR2(240), "SCOPE" VARCHAR2(240), "NUMERIC_VAL"
"UE" NUMBER(15, 2), "CHAR_VALUE" VARCHAR2(240), "DATE_VALUE" DATE, "LONG_VAL"
"UE" LONG) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 61"
"440 NEXT 53248 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 0 FREELISTS 1 FREELI"
"ST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "USER_PROFILE" ("PRODUCT" VARCHAR2(30), "USERID" VARCHAR2(30),"
" "PROFILE" VARCHAR2(240), "ATTRIBUTE" VARCHAR2(240), "NUMERIC_VALUE" NUMBER"
"(15, 2), "CHAR_VALUE" VARCHAR2(240), "DATE_VALUE" DATE, "LONG_VALUE" LONG) "
" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 61440 NEXT 5"
"3248 MINEXTENTS 1 MAXEXTENTS 249 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS "
"1) "
. importing INSIGHT's objects into INSIGHT
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "ACC_TYPE" ("I_CODE" NUMBER(4, 0), "I_DESC" VARCHAR2(30) NOT N"
"ULL, "E_I_DESC" VARCHAR2(30) NOT NULL, "I_SHORT" VARCHAR2(1) NOT NULL, "E_I"
"_SHORT" VARCHAR2(1) NOT NULL, "UPD_TIME" DATE, "USR_CODE" VARCHAR2(4), "CLI"
"ENT_ACC" VARCHAR2(1)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 4 STORAGE("
"INITIAL 40960 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 221 PCTINCREASE 0 FREELISTS"
" 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "ALL_PORT" ("COMP_ID" NUMBER(4, 0), "CLIENT_ID" NUMBER(9, 0), "
""USR_CODE" VARCHAR2(4), "BUY_QTY" NUMBER(10, 0), "SELL_QTY" NUMBER(10, 0), "
""TOT_BUY" NUMBER(15, 3), "TOT_SELL" NUMBER(15, 3), "QTY" NUMBER(10, 0), "P_"
"COST" NUMBER(15, 3), "PS_VALUE" NUMBER(15, 3), "PR_C_PRICE" NUMBER(15, 3), "
""PR_PRICE_DATE" DATE, "N_VALUE" NUMBER(15, 3), "P_PROF" NUMBER(15, 3), "P_P"
"ERC" NUMBER(15, 3), "E_PRICE" NUMBER(15, 3), "COMM" NUMBER(15, 3), "M_COMM""
" NUMBER(15, 3), "NEW_VALUE" NUMBER(15, 3), "PROFIT" NUMBER(15, 3), "D_PROF""
" NUMBER(15, 3), "N_R_PROF" NUMBER(15, 3)) PCTFREE 10 PCTUSED 40 INITRANS 1"
" MAXTRANS 4 STORAGE(INITIAL 1536000 NEXT 512000 MINEXTENTS 1 MAXEXTENTS 221"
" PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_INTEREST" ("CLIENT_ID" NUMBER(9, 0), "U_CODE" VARCHAR2(4), "
""SUMDEBIT" NUMBER(15, 3), "SUMCREDIT" NUMBER(15, 3), "ENDBAL" NUMBER(15, 3)"
") PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 4 STORAGE(INITIAL 20480 NEXT 1"
"6384 MINEXTENTS 1 MAXEXTENTS 221 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS "
"1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_LATE_FEES" ("CLIENT_ID" NUMBER(9, 0) NOT NULL, "U_CODE" VAR"
"CHAR2(4) NOT NULL, "SUMDEBIT" NUMBER(15, 3), "ENDBAL" NUMBER(15, 3)) PCTFR"
"EE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 8192 NEXT 4096 MIN"
"EXTENTS 1 MAXEXTENTS 249 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) "
" "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_MARGIN" ("CLIENT_ID" NUMBER(13, 0), "U_CODE" VARCHAR2(4), ""
"MARKET_VALUE" NUMBER(15, 3), "CREDIT_AMT" NUMBER(15, 3), "BALANCE" NUMBER(1"
"5, 3), "FACILITY_AMT" NUMBER(15, 3), "CREDIT_PERCENT" NUMBER(5, 2), "ACTUAL"
"_CREDIT" NUMBER(15, 3), "PROFIT" NUMBER(15, 3)) PCTFREE 10 PCTUSED 40 INIT"
"RANS 1 MAXTRANS 4 STORAGE(INITIAL 20480 NEXT 16384 MINEXTENTS 1 MAXEXTENTS "
"221 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_PERFORMANCE" ("CLIENT_ID" NUMBER(13, 0), "U_CODE" VARCHAR2("
"4), "REALIZED_PROFIT" NUMBER(15, 3), "EXPECTED_PROFIT" NUMBER(15, 3), "INTE"
"REST" NUMBER(15, 3), "ADMIN_FEES" NUMBER(15, 3), "NET_PROFIT" NUMBER(15, 3)"
", "PERFORMANCE_AMT" NUMBER(15, 3)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRA"
"NS 4 STORAGE(INITIAL 20480 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 221 PCTINCREA"
"SE 0 FREELISTS 1 FREELIST GROUPS 1) "
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "T_TEMP_FCS" ("FC_ID" NUMBER(15, 0) NOT NULL, "FC_MRK_TYPE" VA"
"RCHAR2(4) NOT NULL, "FC_DATE" DATE NOT NULL, "FC_SYS_ID" NUMBER(15, 0) NOT "
"NULL, "FC_TIME" DATE NOT NULL, "FC_SHRS_QTY" NUMBER(12, 0) NOT NULL, "FC_TY"
"PE" VARCHAR2(4) NOT NULL, "FC_SHARE_PRICE" NUMBER(13, 3) NOT NULL, "FC_COMP"
"_ID" NUMBER(4, 0) NOT NULL, "FC_BUYER_BROKER_ID" NUMBER(4, 0) NOT NULL, "FC"
"_SELLER_BROKER_ID" NUMBER(4, 0) NOT NULL, "FC_STATUS" VARCHAR2(4) NOT NULL,"
" "FC_CORRECT_FLAG" VARCHAR2(1) NOT NULL, "FC_USR_GRP" VARCHAR2(3) NOT NULL,"
" "FC_ENT_DATE" DATE NOT NULL, "FC_MOD_DATE" DATE NOT NULL, "FC_USER" VARCHA"
"R2(6) NOT NULL, "FC_TERM_ID" VARCHAR2(5) NOT NULL) PCTFREE 10 PCTUSED 40 I"
"NITRANS 1 MAXTRANS 255 STORAGE(INITIAL 1064960 NEXT 4194304 MINEXTENTS 1 MA"
"XEXTENTS 121 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) "
" "
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
|
|
|
Re: How to import DUMP file to a new database? [message #209372 is a reply to message #209371] |
Thu, 14 December 2006 08:11 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You'll need to use the parameter ignore=y
Where was this export from, a version 7 database? DMT are not supported anymore.
And you could not have created a "new" database if all the objects already exist in it. Please tell use step by step what you did from the export with the exact command you used, to the import with the exact command you used.
also give us the OS and version of both databases.
|
|
|
Re: How to import DUMP file to a new database? [message #209373 is a reply to message #209372] |
Thu, 14 December 2006 08:14 |
braimi
Messages: 18 Registered: December 2006 Location: Muscat
|
Junior Member |
|
|
I exported the file by using command 'exp insight/brok@brok full = y file = h:\backup.dmp log = h:\backup.log'
and imported the file using command 'imp system/system@test full = y file = h:\backup.dmp log = h:\backup.log
and the OS is windows server 2003
|
|
|
Re: How to import DUMP file to a new database? [message #209375 is a reply to message #209373] |
Thu, 14 December 2006 08:17 |
braimi
Messages: 18 Registered: December 2006 Location: Muscat
|
Junior Member |
|
|
now i deleted all the data from new databse but still getting these errors
Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V07.03.04 via conventional path
Warning: the objects were exported by INSIGHT, not by you
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_RBS" DATAFILE 'C:\BROK\BRK2_RBS.DBF' SIZE 62914560 "
" DEFAULT STORAGE (INITIAL 20480 NEXT 20480 MINEXTENTS 1 MAXEXTENTS 249 "
"PCTINCREASE 50) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_TEMP" DATAFILE 'C:\BROK\BRK2_TEMP.DBF' SIZE 31457280"
" DEFAULT STORAGE (INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS"
" 249 PCTINCREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "DB_TOOLS" DATAFILE 'C:\BROK\BRK2_TOOLS.DBF' SIZE 314572"
"80 DEFAULT STORAGE (INITIAL 53248 NEXT 53248 MINEXTENTS 1 MAXEXTENTS "
"249 PCTINCREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_01" DATAFILE 'C:\BROK\TS_01.DBF' SIZE 734003200 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_02" DATAFILE 'C:\BROK\TS_02.DBF' SIZE 125829120 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 12913:
"CREATE TABLESPACE "TS_03" DATAFILE 'C:\BROK\TS_03.DBF' SIZE 104857600 "
" DEFAULT STORAGE (INITIAL 8192 NEXT 4096 MINEXTENTS 1 MAXEXTENTS 249 PCTIN"
"CREASE 0) ONLINE PERMANENT EXTENT MANAGEMENT DICTIONARY"
IMP-00003: ORACLE error 12913 encountered
ORA-12913: Cannot create dictionary managed tablespace
IMP-00017: following statement failed with ORACLE error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' DEFAULT TABLESP"
"ACE "DB_TOOLS" TEMPORARY TABLESPACE "DB_TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DB_TOOLS' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "INSIGHT" IDENTIFIED BY VALUES '1190353FF4D40B17' DEFAULT TABLE"
"SPACE "TS_01" TEMPORARY TABLESPACE "DB_TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ADM" IDENTIFIED BY VALUES '9061A022C3C770AD' DEFAULT TABLESPAC"
"E "TS_01" TEMPORARY TABLESPACE "DB_TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_01' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "FAISAL" IDENTIFIED BY VALUES '4223CD883484E9D5' DEFAULT TABLES"
"PACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ALAA" IDENTIFIED BY VALUES '169BB1EE51D98F39' DEFAULT TABLESPA"
"CE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "HAFY" IDENTIFIED BY VALUES 'AB3BAA27B909BB5E' DEFAULT TABLESPA"
"CE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ABDULRAHMAN" IDENTIFIED BY VALUES 'ABDA52C7A1A7AF82' DEFAULT T"
"ABLESPACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "HAMAD" IDENTIFIED BY VALUES '51E76A0CFB07A891' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "HAMED" IDENTIFIED BY VALUES '2EC3DE9D28736E2F' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ALHAFI" IDENTIFIED BY VALUES '0FBD548DA3439832' DEFAULT TABLES"
"PACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ABDUL" IDENTIFIED BY VALUES 'CE522F6E7917CFD8' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ALAA1" IDENTIFIED BY VALUES '7D0F9AE387B415F6' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "ALA" IDENTIFIED BY VALUES 'EF38CB79D981542C' DEFAULT TABLESPAC"
"E "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "CEO" IDENTIFIED BY VALUES '1004E08011D692A7' DEFAULT TABLESPAC"
"E "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "SAHAR" IDENTIFIED BY VALUES '76DCE0EB5F552036' DEFAULT TABLESP"
"ACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "SAFIYA" IDENTIFIED BY VALUES '4535DB8F5346D1B9' DEFAULT TABLES"
"PACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 959:
"CREATE USER "MAHMOUD" IDENTIFIED BY VALUES 'BA78FDB73F42D837' DEFAULT TABLE"
"SPACE "TS_02""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TS_02' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE ANY VIEW to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE CLUSTER to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE DATABASE LINK to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PUBLIC DATABASE LINK to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PROFILE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PROCEDURE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE PUBLIC SYNONYM to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE ROLE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SEQUENCE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SNAPSHOT to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SYNONYM to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE TABLE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE TRIGGER to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE VIEW to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ANY TABLE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP PUBLIC DATABASE LINK to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DROP PUBLIC SYNONYM to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ANALYZE ANY to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UNLIMITED TABLESPACE to "INSIGHT" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "FAISAL" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'FAISAL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ALAA" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALAA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "HAFY" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAFY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ABDULRAHMAN" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ABDULRAHMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "HAMAD" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAMAD' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "HAMED" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAMED' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ALHAFI" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALHAFI' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ABDUL" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ABDUL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ALAA1" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALAA1' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "ALA" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "CEO" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CEO' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "SAHAR" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SAHAR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "SAFIYA" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SAFIYA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT CREATE SESSION to "MAHMOUD" "
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MAHMOUD' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DBA" TO "INSIGHT""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "CONNECT" TO "ADM""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ADM""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "FAISAL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'FAISAL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ALAA""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALAA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "HAFY""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAFY' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ABDULRAHMAN""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ABDULRAHMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "HAMAD""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAMAD' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "HAMED""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HAMED' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ALHAFI""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALHAFI' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ABDUL""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ABDUL' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ALAA1""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALAA1' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "ALA""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'ALA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "CEO""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CEO' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "SAHAR""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SAHAR' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "SAFIYA""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'SAFIYA' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "DEV" TO "MAHMOUD""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'MAHMOUD' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "INSIGHT" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'INSIGHT' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "HAMED" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'HAMED' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ADM" DEFAULT ROLE "DEV""
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ADM' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "FAISAL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'FAISAL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALAA" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALAA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "HAFY" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'HAFY' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ABDULRAHMAN" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ABDULRAHMAN' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "HAMAD" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'HAMAD' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALHAFI" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALHAFI' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ABDUL" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ABDUL' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALAA1" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALAA1' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "ALA" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'ALA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "CEO" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'CEO' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SAHAR" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SAHAR' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "SAFIYA" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'SAFIYA' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
"ALTER USER "MAHMOUD" DEFAULT ROLE ALL"
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'MAHMOUD' does not exist
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT SYSTEM1 STORAGE (INITIAL 53248 NEXT 1064960 MINEXTE"
"NTS 2 MAXEXTENTS 41) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB01 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB02 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB03 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB04 STORAGE (INITIAL 102400 NEXT 1064960 MINEXTENT"
"S 5 MAXEXTENTS 40) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
IMP-00017: following statement failed with ORACLE error 30019:
"CREATE ROLLBACK SEGMENT DB_DEL STORAGE (INITIAL 1024000 NEXT 1024000 MINEXT"
"ENTS 2 MAXEXTENTS 121) TABLESPACE "DB_RBS""
IMP-00003: ORACLE error 30019 encountered
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
. importing INSIGHT's objects into INSIGHT
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
. . importing table "DEF$_CALL" 0 rows imported
. . importing table "DEF$_CALLDEST" 0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"CREATE INDEX "DEF$_CALLDEST_N1" ON "DEF$_CALLDEST" ("DEFERRED_TRAN_DB" , "D"
"EFERRED_TRAN_ID" , "CALLNO" , "DUMMY_BUFFER_NUMBER" ) PCTFREE 10 INITRANS "
"2 MAXTRANS 255 STORAGE (INITIAL 12288 NEXT 12288 MINEXTENTS 1 MAXEXTENTS 24"
"9 PCTINCREASE 50 FREELISTS 1) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DUMMY_BUFFER_NUMBER": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF$_CALLDEST_PRIMARY" PRIMARY"
" KEY ("DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","CALLNO","DBLINK") USING INDEX "
"PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 12288 NEXT 12288 MINEXT"
"ENTS 1 MAXEXTENTS 249 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_DB": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_DB" IS 'Originating datab"
"ase for the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_DB": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DEFERRED_TRAN_ID" IS 'Transaction ID'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_ID": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."CALLNO" IS 'Unique ID of call within tr"
"ansaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "CALLNO": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_CALLDEST"."DUMMY_BUFFER_NUMBER" IS 'Used for forei"
"gn key reference only'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DUMMY_BUFFER_NUMBER": invalid identifier
. . importing table "DEF$_DEFAULTDEST" 0 rows imported
. . importing table "DEF$_DESTINATION" 0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_ID" IS 'Transaction ID of "
"last transaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "LAST_TRAN_ID": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_TRAN_DB" IS 'Source of last tra"
"nsaction propagated'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "LAST_TRAN_DB": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_ERROR" IS 'Oracle error number "
"from last push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "LAST_ERROR": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_DESTINATION"."LAST_MSG" IS 'Error message from las"
"t push'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "LAST_MSG": invalid identifier
. . importing table "DEF$_ERROR" 0 rows imported
IMP-00017: following statement failed with ORACLE error 904:
"ALTER TABLE "DEF$_ERROR" ADD CONSTRAINT "DEF$_ERROR_PRIMARY" PRIMARY KEY ("
""DEFERRED_TRAN_DB","DEFERRED_TRAN_ID","DESTINATION") USING INDEX PCTFREE 10"
" INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 12288 NEXT 12288 MINEXTENTS 1 MAX"
"EXTENTS 249 PCTINCREASE 50 FREELISTS 1 ) TABLESPACE "SYSTEM""
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_DB": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_DB" IS 'The database origina"
"ting or copying the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_DB": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."DEFERRED_TRAN_ID" IS 'The ID of the transa"
"ction that originated or copied the deferred transaction'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "DEFERRED_TRAN_ID": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."CALLNO" IS 'Unique ID of call that caused "
"an error'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "CALLNO": invalid identifier
IMP-00017: following statement failed with ORACLE error 904:
"COMMENT ON COLUMN "DEF$_ERROR"."ERROR_TIME" IS 'Time error occurred'"
IMP-00003: ORACLE error 904 encountered
ORA-00904: "ERROR_TIME": invalid identifier
. . importing table "PRODUCT_PROFILE" 0 rows imported
. . importing table "USER_PROFILE" 0 rows imported
. importing INSIGHT's objects into INSIGHT
"ALTER SESSION SET CURRENT_SCHEMA= "INSIGHT""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
|
|
|
Re: How to import DUMP file to a new database? [message #209379 is a reply to message #209371] |
Thu, 14 December 2006 08:28 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
hi,
ORA-12913: Cannot create dictionary managed tablespace
This error bcoz ur system tablespace in ur database is ( LMT) you have try to create ( DMT) that it is not possible.
action.> you have to create new tablespace with LMT.
or create database again.
[code]
create tablespace TEST1
datafile 'd:\oracle\test101.dbf' size 1000m
extent management local;
alter database default tablespace TEST1;
ORA-01917: user or role 'ADM' does not exist
above error bcoz of user "ADM" is not exists in ur database.
action.> first create 'ADM' user in database
create user ADM identified by ADM default tablespace &tablespacename quota unlimited on &tablespace
ORA-10615: Invalid tablespace type for temporary tablespace
Create default temporary tablespace.
create temporary tablespace TEST
tempfile 'd:\oracle\test01.dbf' size 1000m
AUTOEXTEND OFF;
alter database default temporary tablespace TEST
according ur need you can specify tbs size.
IMP-00015: following statement failed because the object already exists:
in imp scirpt used ignore=y
regards
Taj
[Updated on: Thu, 14 December 2006 08:32] Report message to a moderator
|
|
|
|
|
Re: How to import DUMP file to a new database? [message #209385 is a reply to message #209379] |
Thu, 14 December 2006 08:44 |
braimi
Messages: 18 Registered: December 2006 Location: Muscat
|
Junior Member |
|
|
tablespace is created successfully but when i try to create ADM i got this error
1* create user ADM identified by ADM default tablespace &tablespacename quota unlimited on &tables
2 /
Enter value for tablespacename: test1
Enter value for tablespace: test1
old 1: create user ADM identified by ADM default tablespace &tablespacename quota unlimited on &ta
new 1: create user ADM identified by ADM default tablespace test1 quota unlimited on test1/
create user ADM identified by ADM default tablespace test1 quota unlimited on test1/
*
ERROR at line 1:
ORA-00922: missing or invalid option
|
|
|
Re: How to import DUMP file to a new database? [message #209387 is a reply to message #209385] |
Thu, 14 December 2006 08:47 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
hi,
SQL> create user ADM identified by ADM default tablespace &tablespacename quota
unlimited on &tables
2 /
Enter value for tablespacename: oracle
Enter value for tables: oracle
old 1: create user ADM identified by ADM default tablespace &tablespacename qu
ota unlimited on &tables
new 1: create user ADM identified by ADM default tablespace oracle quota unlim
ited on oracle
User created.
create user ADM identified by ADM default tablespace test1 quota unlimited on test1/
|
|
|
Goto Forum:
Current Time: Wed Apr 24 19:20:42 CDT 2024
|