OraFAQ Forum: Server Utilities » import in 10g

Home » RDBMS Server » Server Utilities » import in 10g (oracle,10g)

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

import in 10g [message #308302]

Mon, 24 March 2008 00:22

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

Report message to a moderator

Re: import in 10g [message #308306 is a reply to message #308302]

Mon, 24 March 2008 00:37

BlackSwan
Messages: 26766
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

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.

Report message to a moderator

Re: import in 10g [message #308312 is a reply to message #308302]

Mon, 24 March 2008 00:54

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.

Report message to a moderator

Re: import in 10g [message #308314 is a reply to message #308302]

Mon, 24 March 2008 00:54

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: import in 10g [message #308315 is a reply to message #308312]

Mon, 24 March 2008 00:59

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

Report message to a moderator

Re: import in 10g [message #308316 is a reply to message #308315]

Mon, 24 March 2008 01:00

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

i have to increase the size after getting the above error.

Report message to a moderator

Re: import in 10g [message #308319 is a reply to message #308302]

Mon, 24 March 2008 01:02

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.

Report message to a moderator

Re: import in 10g [message #308320 is a reply to message #308302]

Mon, 24 March 2008 01:02

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: import in 10g [message #308322 is a reply to message #308302]

Mon, 24 March 2008 01:04

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.

Report message to a moderator

Re: import in 10g [message #308325 is a reply to message #308322]

Mon, 24 March 2008 01:06

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

ok ..
let me check the free space in a particular tablespace.

Report message to a moderator

Re: import in 10g [message #308330 is a reply to message #308325]

Mon, 24 March 2008 01:10

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.

Report message to a moderator

Re: import in 10g [message #308334 is a reply to message #308302]

Mon, 24 March 2008 01:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>why should i solve this.
To eliminate the error (or not).
It is your choice.

Report message to a moderator

Re: import in 10g [message #308335 is a reply to message #308334]

Mon, 24 March 2008 01:18

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.

Report message to a moderator

Re: import in 10g [message #308337 is a reply to message #308302]

Mon, 24 March 2008 01:22

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

Report message to a moderator

Re: import in 10g [message #308338 is a reply to message #308337]

Mon, 24 March 2008 01:24

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

ok..
i did it
but i am getting the same error.

Report message to a moderator

Re: import in 10g [message #308340 is a reply to message #308302]

Mon, 24 March 2008 01:29

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.

Report message to a moderator

Re: import in 10g [message #308341 is a reply to message #308340]

Mon, 24 March 2008 01:31

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

ok..
let me try this one

Report message to a moderator

Re: import in 10g [message #308350 is a reply to message #308341]

Mon, 24 March 2008 01:59

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

Report message to a moderator

Re: import in 10g [message #308367 is a reply to message #308350]

Mon, 24 March 2008 02:39

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

Report message to a moderator

Previous Topic:	Error while loading data using SQLLDR
Next Topic:	continue if ina sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:43:10 CST 2024