Home » RDBMS Server » Server Utilities » Getting error during importing
Getting error during importing [message #293409] Sat, 12 January 2008 05:36 Go to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i import the ".dmp" file sucessfully but during the importing process i am getting error messages.i am sending the scree shots of the error message, with my message.after import when i count total number of triggers,constraints ,indexes ,tables ,i found that the number of tables is same but i lost some of the triggers ,constraints ,indexes to create.

regards
jitender.
  • Attachment: untitled1.bmp
    (Size: 804.06KB, Downloaded 171 times)
Re: getting error during importing [message #293414 is a reply to message #293409] Sat, 12 January 2008 06:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
How did you export?
Always export with explicit compress = n.
Seems your initial segment need to be larger.
Re: getting error during importing [message #293425 is a reply to message #293409] Sat, 12 January 2008 09:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Defragment and/or enlarge your tablespace before import.

Regards
Michel
Re: getting error during importing [message #293636 is a reply to message #293425] Mon, 14 January 2008 05:57 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i am sending the screen shot of the procedure which i follow for backup,i also extend the size of tablespace and provide maxsize unlimited but after that i am also getting errors.


regards
jitender.
  • Attachment: untitled4.bmp
    (Size: 845.49KB, Downloaded 155 times)
Re: getting error during importing [message #293638 is a reply to message #293636] Mon, 14 January 2008 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no error in the screeshot you posted.

Instead of posting images, just copy and paste your screen.
Before, please read OraFAQ Forum Guide, "How to format your post?" section.

Regards
Michel
Re: getting error during importing [message #293650 is a reply to message #293638] Mon, 14 January 2008 06:53 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

here the error messages screens

c:\untitled2.bmp

c:\untitled1.bmp


regards
jitender.




Re: getting error during importing [message #293654 is a reply to message #293650] Mon, 14 January 2008 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't put screen, I don't see it.
Copy and paste TEXT.

Regards
Michel
Re: getting error during importing [message #293842 is a reply to message #293654] Tue, 15 January 2008 04:25 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

ok here is the error text
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE INDEX "IND_DB_CR" ON "FAC_VCH_D" ("VCH_LOCN_CODE" , "VCH_VCH_DATE" ,"
 " "VCH_GL_CODE" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 277196"
 "80 NEXT 13856768 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS"
 " 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace INDX
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE INDEX "IND_VCHD2" ON "FAC_VCH_D" ("VCH_DATE_CR" )  PCTFREE 10 INITRA"
 "NS 2 MAXTRANS 255 STORAGE(INITIAL 12308480 NEXT 4102144 MINEXTENTS 1 MAXEXT"
 "ENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEF"
 "AULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace INDX
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE INDEX "IND_LOCN_DATE" ON "FAC_VCH_D" ("VCH_LOCN_CODE" , "VCH_VCH_DAT"
 "E" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 21022720 NEXT 1051"
 "0336 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST "
 "GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace INDX
IMP-00017: following statement failed with ORACLE error 1658:
 "CREATE INDEX "FAC_VCH_D_SR" ON "FAC_VCH_D" ("VCH_VCH_TYPE" , "VCH_VCH_#" , "
 ""VCH_SRL_#" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 23224320 "
 "NEXT 11608064 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 "
 "FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered


i also attach text file


regards
jitender
  • Attachment: log.txt
    (Size: 352.30KB, Downloaded 803 times)
Re: getting error during importing [message #293846 is a reply to message #293842] Tue, 15 January 2008 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not enough free space.

Regards
Michel

[Updated on: Tue, 15 January 2008 04:41]

Report message to a moderator

Re: getting error during importing [message #293847 is a reply to message #293846] Tue, 15 January 2008 04:45 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i parovide maxsize unlimited , during tablespace creation.

SQL> CREATE TABLESPACE NDS DATAFILE 'D:\DATAFILES\NDS.DMP' SIZE 4600M
  2  AUTOEXTEND ON NEXT 450M
  3  MAXSIZE UNLIMITED
  4    extent management local;

Tablespace created.


regards
jitender.
Re: getting error during importing [message #293849 is a reply to message #293847] Tue, 15 January 2008 04:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The tablespace is INDX.

Regards
Michel
Re: getting error during importing [message #294016 is a reply to message #293849] Wed, 16 January 2008 00:56 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi

i increased the size of tablespace INDX and the number of tables,constarints,index are same but still i am getting error during trigger export.

. . importing table          "FAC_VCH_D_PROV_BACK"          0 rows imported
. . importing table    "FAC_VCH_D_PROV_MLP_200106"          0 rows imported
. . importing table           "FAC_VCH_D_PRV_TEMP"          0 rows imported
. . importing table                "FAC_VCH_D_TDS"          0 rows imported
. . importing table                  "FAC_VCH_EXP"       1558 rows imported
. . importing table                "FAC_VCH_EXP_P"          0 rows imported
. . importing table              "FAC_VCH_EXP_TDS"          0 rows imported
. . importing table               "FAC_VCH_FRGTSC"          0 rows imported
. . importing table               "FAC_VCH_LTCEXP"          0 rows imported
------------------------------------------------------------------------------------
. . importing table                    "FAC_VCH_M"      19594 rows imported
------------------------------------------------------------------------------------
. . importing table            "FAC_VCH_MPRV_TEMP"          0 rows imported
. . importing table               "FAC_VCH_M_PROV"          1 rows imported
. . importing table           "FAC_VCH_M_PROV_MLP"          0 rows imported
. . importing table               "FAC_VCH_SCRPSL"          0 rows imported
. . importing table               "FAC_VCH_TELEXP"          0 rows imported


IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
 "CREATE TRIGGER "NDS"."AFETR_INSERT" AFTER INSERT ON NEWTON.FAC_VCH_M REFERE"
 "NCING NEW AS NEW OLD AS OLD FOR EACH ROW  "
 "DECLARE"
 "  TEMP_DIV_CODE VARCHAR2(6);"
 "  TEMP_VC_NUM VARCHAR2(7);"
 "  TEMP_VC_TP VARCHAR2(4);"



regards
jitender.
Re: getting error during importing [message #294018 is a reply to message #294016] Wed, 16 January 2008 01:03 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What's INSIDE the trigger? Have a look at it.

Regards
Michel
Previous Topic: A few doubts in importing and exporting data
Next Topic: Importing from a pendrive
Goto Forum:
  


Current Time: Mon Dec 05 13:21:13 CST 2016

Total time taken to generate the page: 0.14248 seconds