OraFAQ Forum: Server Utilities » Getting error during importing

Home » RDBMS Server » Server Utilities » Getting error during importing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting error during importing [message #293409]

Sat, 12 January 2008 05:36

jitender.sadh
Messages: 86
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 933 times)

Report message to a moderator

Re: getting error during importing [message #293414 is a reply to message #293409]

Sat, 12 January 2008 06:20

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: getting error during importing [message #293425 is a reply to message #293409]

Sat, 12 January 2008 09:22

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Defragment and/or enlarge your tablespace before import.

Regards
Michel

Report message to a moderator

Re: getting error during importing [message #293636 is a reply to message #293425]

Mon, 14 January 2008 05:57

jitender.sadh
Messages: 86
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 884 times)

Report message to a moderator

Re: getting error during importing [message #293638 is a reply to message #293636]

Mon, 14 January 2008 06:01

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: getting error during importing [message #293650 is a reply to message #293638]

Mon, 14 January 2008 06:53

jitender.sadh
Messages: 86
Registered: May 2007

Member

hi

here the error messages screens

$c:\untitled2.bmp$

$c:\untitled1.bmp$

regards
jitender.

Report message to a moderator

Re: getting error during importing [message #293654 is a reply to message #293650]

Mon, 14 January 2008 07:20

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: getting error during importing [message #293842 is a reply to message #293654]

Tue, 15 January 2008 04:25

jitender.sadh
Messages: 86
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 1859 times)

Report message to a moderator

Re: getting error during importing [message #293846 is a reply to message #293842]

Tue, 15 January 2008 04:40

Michel Cadot
Messages: 68665
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

jitender.sadh
Messages: 86
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.

Report message to a moderator

Re: getting error during importing [message #293849 is a reply to message #293847]

Tue, 15 January 2008 04:50

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The tablespace is INDX.

Regards
Michel

Report message to a moderator

Re: getting error during importing [message #294016 is a reply to message #293849]

Wed, 16 January 2008 00:56

jitender.sadh
Messages: 86
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.

Report message to a moderator

Re: getting error during importing [message #294018 is a reply to message #294016]

Wed, 16 January 2008 01:03

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What's INSIDE the trigger? Have a look at it.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 06:01:28 CDT 2024