OraFAQ Forum: Server Utilities » Export Not completed

Home » RDBMS Server » Server Utilities » Export Not completed

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

Export Not completed [message #272463]

Fri, 05 October 2007 02:51

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hi,

I'm using oracle 10g R2 in windows 2003 server. If i export one user it's not completed.

If i login "EDKALINVENTORY" user SQLPLUS will be hanged.

I think some problem in "CONSUMPTIONCATEGORYMASTER". How to resolve this issue.

C:\>exp EDKALINVENTORY/EDKALINVENTORY@EDKDB file=C:\DBBackup\EdkalDB\Export\EDKALINVENTORY.DMP Owner=EDKALINVENTORY LOG=C:\DBBackup\EdkalDB\Log\E
DKALINVENTORY.LOG

Export: Release 10.2.0.1.0 - Production on Fri Oct 5 13:10:50 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user EDKALINVENTORY
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EDKALINVENTORY
About to export EDKALINVENTORY's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export EDKALINVENTORY's tables via Conventional Path ...
. . exporting table ADJUSTMENTREASONMASTER 0 rows exported
. . exporting table ARNOREGISTER 0 rows exported
. . exporting table AUTHORISATIONTYPEMASTER 0 rows exported
. . exporting table AUTHORISINGPERSONMASTER 0 rows exported
. . exporting table CATEGORYCHANGE 0 rows exported
. . exporting table CATEGORYCHANGE_EXT 0 rows exported
. . exporting table COMPANYMASTER 1 rows exported
. . exporting table CONSUMPTIONCATEGORYMASTER

Report message to a moderator

Re: Export Not completed [message #272468 is a reply to message #272463]

Fri, 05 October 2007 03:10

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

Senior Member
Account Moderator

Activate a trace on the export session to see what is currently happening

Regards
Michel

Report message to a moderator

Re: Export Not completed [message #272482 is a reply to message #272468]

Fri, 05 October 2007 04:10

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

In the trace file what kind of information come?

Report message to a moderator

Re: Export Not completed [message #272490 is a reply to message #272482]

Fri, 05 October 2007 04:36

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

Senior Member
Account Moderator

What the export is currently doing or waiting at internal level.

Regards
Michel

Report message to a moderator

Re: Export Not completed [message #272500 is a reply to message #272490]

Fri, 05 October 2007 04:56

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Michel,

If i export that user it's not completed. I think some problem happening in this session. Because if i select "CONSUMPTIONCATEGORYMASTER" - this table application got hanged even told also.

So, I think problem in CONSUMPTIONCATEGORYMASTER table.

I want to know what is the problem?

Babu

[Updated on: Fri, 05 October 2007 05:23]

Report message to a moderator

Re: Export Not completed [message #272506 is a reply to message #272500]

Fri, 05 October 2007 05:24

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

Senior Member
Account Moderator

Michel Cadot wrote on Fri, 05 October 2007 10:10

Activate a trace on the export session to see what is currently happening

Regards
Michel

Report message to a moderator

Re: Export Not completed [message #272508 is a reply to message #272506]

Fri, 05 October 2007 05:40

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Ok..Find my attachment.

Babu

[Edit: attachment removed by OP]

[Updated on: Fri, 05 October 2007 06:32] by Moderator

Report message to a moderator

Re: Export Not completed [message #272511 is a reply to message #272508]

Fri, 05 October 2007 06:10

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

Senior Member
Account Moderator

I don't want the trace of YOUR session but of export one.

Regards
Michel

Report message to a moderator

Re: Export Not completed [message #272514 is a reply to message #272511]

Fri, 05 October 2007 06:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Dump file d:\oracle\product\10.2.0\admin\edkdb\udump\edkdb_ora_2892.trc
Fri Oct 05 16:04:19 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.1.0 - Production
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:48M/503M, Ph+PgF:898M/1697M, VA:1629M/2047M
Instance name: edkdb

Redo thread mounted by this instance: 1

Oracle process number: 38

Windows thread id: 2892, image: ORACLE.EXE (SHAD)

*** 2007-10-05 16:04:19.670
*** ACTION NAME:() 2007-10-05 16:04:19.607
*** MODULE NAME:(SQL*Plus) 2007-10-05 16:04:19.607
*** SERVICE NAME:(edkdb.samiindia) 2007-10-05 16:04:19.607
*** SESSION ID:(120.14039) 2007-10-05 16:04:19.607
=====================
PARSING IN CURSOR #3 len=32 dep=0 uid=5 oct=42 lid=5 tim=3306258614 hv=2097336573 ad='696c4578'
ALTER SESSION SET SQL_TRACE=TRUE
END OF STMT
EXEC #3:c=0,e=491,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=3306258609
*** 2007-10-05 16:04:36.795
=====================
PARSING IN CURSOR #1 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323438812 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #1:c=15625,e=2083,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=3323438805
EXEC #1:c=0,e=2614,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=3323669620
FETCH #1:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323675079
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=31 us)'
=====================
PARSING IN CURSOR #5 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323686509 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #5:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323686503
EXEC #5:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323718456
FETCH #5:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323723946
STAT #5 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=30 us)'
=====================
PARSING IN CURSOR #3 len=37 dep=1 uid=0 oct=3 lid=0 tim=3323735463 hv=1398610540 ad='6cef4310'
select text from view$ where rowid=:1
END OF STMT
PARSE #3:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323735457
EXEC #3:c=0,e=47,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3323768419
FETCH #3:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3323773993
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=63 op='TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=30 us)'
=====================
PARSING IN CURSOR #4 len=302 dep=0 uid=5 oct=3 lid=5 tim=3323819075 hv=3347503714 ad='6751fa00'
SELECT s.sid, s.serial#, pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name'))
|| '_j000_' || p.spid || '.trc' AS trace_file FROM v$session s, v$process p, v$parameter pa
WHERE pa.name = 'user_dump_dest' AND s.paddr = p.addr
AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID')
END OF STMT
PARSE #4:c=78125,e=383068,p=0,cr=6,cu=0,mis=1,r=0,dep=0,og=1,tim=3323819068
EXEC #4:c=0,e=86,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3323875183
FETCH #4:c=15625,e=10385,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,tim=3323893423
FETCH #4:c=0,e=1098,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=3323903595
STAT #4 id=1 cnt=1 pid=0 pos=1 obj=0 op='HASH JOIN (cr=0 pr=0 pw=0 time=10360 us)'
STAT #4 id=2 cnt=1381 pid=1 pos=1 obj=0 op='MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=9982 us)'
STAT #4 id=3 cnt=1 pid=2 pos=1 obj=0 op='NESTED LOOPS (cr=0 pr=0 pw=0 time=1137 us)'
STAT #4 id=4 cnt=1 pid=3 pos=1 obj=0 op='HASH JOIN (cr=0 pr=0 pw=0 time=1114 us)'
STAT #4 id=5 cnt=1 pid=4 pos=1 obj=0 op='FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=472 us)'
STAT #4 id=6 cnt=36 pid=4 pos=2 obj=0 op='FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=159 us)'
STAT #4 id=7 cnt=1 pid=3 pos=2 obj=0 op='FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=13 us)'
STAT #4 id=8 cnt=1381 pid=2 pos=2 obj=0 op='BUFFER SORT (cr=0 pr=0 pw=0 time=6367 us)'
STAT #4 id=9 cnt=1381 pid=8 pos=1 obj=0 op='FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=4158 us)'
STAT #4 id=10 cnt=1 pid=1 pos=2 obj=0 op='FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=1036 us)'

Tel me what kind of info. here analyze?

Report message to a moderator

Re: Export Not completed [message #272516 is a reply to message #272514]

Fri, 05 October 2007 06:31

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

Senior Member
Account Moderator

Michel Cadot wrote on Fri, 05 October 2007 13:10

I don't want the trace of YOUR session but of export one.

Regards
Michel

Report message to a moderator

Re: Export Not completed [message #272745 is a reply to message #272463]

Sat, 06 October 2007 23:48

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Oracle database has a feature "Resumable Space Allocation".It does not actually hangs but resumes its work ans after correcting operations by you it starts again.

May be you are out of disk space.

Report message to a moderator

Previous Topic:	full import
Next Topic:	datapump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 05:31:42 CDT 2024