Home » SQL & PL/SQL » SQL & PL/SQL » How to import DUMP file to a new database?
How to import DUMP file to a new database? [message #209355] Thu, 14 December 2006 07:42 Go to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
Please tell me the procedure that how i can import dump file to a new database using oracle 9.2.0.1.0????
Re: How to import DUMP file to a new database? [message #209356 is a reply to message #209355] Thu, 14 December 2006 07:44 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Have you looked at the syntax of the IMP and EXP commands ?
Re: How to import DUMP file to a new database? [message #209357 is a reply to message #209356] Thu, 14 December 2006 07:47 Go to previous messageGo to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
i tried but it looks that i m not using the right command
can u plz tell me the right command?
Re: How to import DUMP file to a new database? [message #209359 is a reply to message #209357] Thu, 14 December 2006 07:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
right command is what in the documents.
You should post what you issued along with exact error messages.
Re: How to import DUMP file to a new database? [message #209360 is a reply to message #209357] Thu, 14 December 2006 07:50 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,


start -----> run -----> cmd <<enter>>

cmd>imp help=y <<enter>>

or

cmd>imp system/manager file=file_name.cmp log=log_file.log ignore=y





try this way what happen reply

regards
Taj

[Updated on: Thu, 14 December 2006 07:50]

Report message to a moderator

Re: How to import DUMP file to a new database? [message #209361 is a reply to message #209355] Thu, 14 December 2006 07:50 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
That's difficult when I don't know what you want to do exactly. What sort of export do you have ? Full database ? Schema ? Individual tables ?
Re: How to import DUMP file to a new database? [message #209363 is a reply to message #209355] Thu, 14 December 2006 07:51 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Do you get an error message ? What is it ?
Re: How to import DUMP file to a new database? [message #209365 is a reply to message #209361] Thu, 14 December 2006 07:54 Go to previous messageGo to next message
braimi
Messages: 18
Registered: December 2006
Location: Muscat
Junior Member
I have a full export and i created a new database now i want to import that full export to the new database

Hi taj i tried the commands you given but it didn't work.
Re: How to import DUMP file to a new database? [message #209367 is a reply to message #209355] Thu, 14 December 2006 07:56 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Excuse me for shouting, but WHAT WAS THE ERROR MESSAGE ?
Re: How to import DUMP file to a new database? [message #209371 is a reply to message #209367] Thu, 14 December 2006 08:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #209382 is a reply to message #209379] Thu, 14 December 2006 08:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
after 580 posts, user52, please try to not use IM-speak...

[Edit: misspelled name]

[Updated on: Thu, 14 December 2006 08:30]

Report message to a moderator

Re: How to import DUMP file to a new database? [message #209383 is a reply to message #209382] Thu, 14 December 2006 08:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Sorry !
Re: How to import DUMP file to a new database? [message #209385 is a reply to message #209379] Thu, 14 December 2006 08:44 Go to previous messageGo to next message
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 Go to previous message
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/
Previous Topic: Insert statement that ignores some rows
Next Topic: deleting char from a string
Goto Forum:
  


Current Time: Sun Dec 04 00:34:05 CST 2016

Total time taken to generate the page: 0.04597 seconds