Home » RDBMS Server » Server Utilities » import in 10g (oracle,10g)
import in 10g [message #308302] Mon, 24 March 2008 00:22 Go to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
Hi Experts,
i am getting while taking imp.
i am unable to find the solution
could you please help me out.
i have pasted error and the command which i used for taking imp.

imp system file=zsuserzspune.dmp log=zsuserzspune_imp.log fromuser=ZSUSER touser=ZSUSER commit=y buffer=10000000

importing table "SSD_ONHAND_FINANCE_REP" 20843 rows imported

. . importing table "SSD_ONHAND_FIN_ELSTMP" 23088 rows imported

. . importing table "SSD_ORG_CYCLE_ENTITY_DETAILS" 635 rows imported

. . importing table "SSD_PENDING_TMP" 60 rows imported

IMP-00017: following statement failed with ORACLE error 1917:

"GRANT SELECT ON "SSD_PENDING_TMP" TO "APPS""

IMP-00003: ORACLE error 1917 encountered

ORA-01917: user or role 'APPS' does not exist

. . importing table "SSD_SF_ONHAND_WIPMOVE" 28738554 rows imported

IMP-00017: following statement failed with ORACLE error 603:

"CREATE UNIQUE INDEX "SFOW_PK" ON "SSD_SF_ONHAND_WIPMOVE" ("SESSIONCODE" , ""

"INVENTORY_ITEM_ID" , "SUBINVENTORY_CODE" , "LOCATOR_ID" ) PCTFREE 10 INITR"

"ANS 2 MAXTRANS 255 STORAGE(INITIAL 1323089920 NEXT 27615232 MINEXTENTS 1 MA"

"XEXTENTS 2147483645 PCTINCREASE 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL"

" DEFAULT) TABLESPACE "USERS" LOGGING"

IMP-00003: ORACLE error 603 encountered

ORA-00603: ORACLE server session terminated by fatal error

IMP-00017: following statement failed with ORACLE error 3114:

"ALTER SESSION SET SKIP_UNUSABLE_INDEXES=FALSE"

IMP-00003: ORACLE error 3114 encountered

ORA-03114: not connected to ORACLE

IMP-00000: Import terminated unsuccessfully
me: ok
wait let me check
amjadshk: AND IN ALERT LOG



[oracle@cloneapps bdump]$ vi alert_clone.log

Current log# 3 seq# 1285 mem# 0: /apps/oracle/ias/infra/oradata/clone/redo03.log




and in alert log i can see this

ORA-1653: unable to extend table ZSUSER.XXX_ZS_MS_TRAN_PEB by 128 in tablespace USERS

ORA-1653: unable to extend table ZSUSER.XXX_ZS_MS_TRAN_PEB by 128 in tablespace USERS

ORA-1652: unable to extend temp segment by 128 in tablespace USERS
Re: import in 10g [message #308306 is a reply to message #308302] Mon, 24 March 2008 00:37 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
so,so, so many errors.
Resolve them 1 at a time.


starting with
>ORA-01917: user or role 'APPS' does not exist

[Updated on: Mon, 24 March 2008 00:38] by Moderator

Report message to a moderator

Re: import in 10g [message #308310 is a reply to message #308306] Mon, 24 March 2008 00:48 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
after increasing the size in temp tablespace .
IMP-00058: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

and more thing i am taking import from 10g to 9i.
please help.
Re: import in 10g [message #308312 is a reply to message #308302] Mon, 24 March 2008 00:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

For which reason you decrease temp tablespace?
Quote:

taking import from 10g to 9i.

What is your heading
Quote:
import in 10g
contradiction.
Re: import in 10g [message #308314 is a reply to message #308302] Mon, 24 March 2008 00:54 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Are you a slow learner?

so,so, so many errors.
Resolve them 1 at a time.


starting with
>ORA-01917: user or role 'APPS' does not exist
Re: import in 10g [message #308315 is a reply to message #308312] Mon, 24 March 2008 00:59 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
actually i didnt decrease the size when i got this error.
i checked the alert log and i found that the error which i have send in the post unable to extent .
cause of this i increase the size .

thanks,
Daniesh
Re: import in 10g [message #308316 is a reply to message #308315] Mon, 24 March 2008 01:00 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
i have to increase the size after getting the above error.
Re: import in 10g [message #308319 is a reply to message #308302] Mon, 24 March 2008 01:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Does it say to extend temp tablespace or any other tablespace? Again run the import. And fix error one by one.
Re: import in 10g [message #308320 is a reply to message #308302] Mon, 24 March 2008 01:02 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>>ORA-01917: user or role 'APPS' does not exist
>>ORA-01917: user or role 'APPS' does not exist
>>ORA-01917: user or role 'APPS' does not exist
Re: import in 10g [message #308322 is a reply to message #308302] Mon, 24 March 2008 01:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
ORA-1653: unable to extend table ZSUSER.XXX_ZS_MS_TRAN_PEB by 128 in tablespace USERS


You have to extend size of users tablespace.
Re: import in 10g [message #308325 is a reply to message #308322] Mon, 24 March 2008 01:06 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
ok ..
let me check the free space in a particular tablespace.
Re: import in 10g [message #308330 is a reply to message #308325] Mon, 24 March 2008 01:10 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
after increasing the size i am not getting this error.

ORA-01917: user or role 'APPS' does not exist

why should i solve this.
Re: import in 10g [message #308334 is a reply to message #308302] Mon, 24 March 2008 01:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>why should i solve this.
To eliminate the error (or not).
It is your choice.
Re: import in 10g [message #308335 is a reply to message #308334] Mon, 24 March 2008 01:18 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
now i am not getting this error now the error which i am getting
after firing the imp command is

IMP-00058: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully

plase dont feel bad
i mean to say after increasing the size i am getting only the above error
why should i go for this error.
please dont mind.
Re: import in 10g [message #308337 is a reply to message #308302] Mon, 24 March 2008 01:22 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You are not getting the error because after increasing the size under users tablespace "APP" user/role created. And about ORA-03113: error huge information need to solve this error in unix. It is a generic error.

If you try to get my suggestion then shutdown the database. and try
step by step startup.

sqlplus nolog>connect / as sysdba>nomount>mount>open
Re: import in 10g [message #308338 is a reply to message #308337] Mon, 24 March 2008 01:24 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
ok..
i did it
but i am getting the same error.
Re: import in 10g [message #308340 is a reply to message #308302] Mon, 24 March 2008 01:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
fromuser=ZSUSER touser=ZSUSER commit=y


Why these settings. Omit these one. And invoke imp with another user rather than system user and see. Also check your network settings.
Re: import in 10g [message #308341 is a reply to message #308340] Mon, 24 March 2008 01:31 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
ok..
let me try this one
Re: import in 10g [message #308350 is a reply to message #308341] Mon, 24 March 2008 01:59 Go to previous messageGo to next message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
i tried i am getting the same error.
i asked my senior he told me to recreate the temp file.

Thanks,
Daniesh
Re: import in 10g [message #308367 is a reply to message #308350] Mon, 24 March 2008 02:39 Go to previous message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
after recreating the temp file. the issue has been resolved.
thanks expert for your precious time.

thanks,
Daniesh
Previous Topic: Error while loading data using SQLLDR
Next Topic: continue if ina sql loader
Goto Forum:
  


Current Time: Sat Dec 10 04:47:54 CST 2016

Total time taken to generate the page: 0.08308 seconds