Home » RDBMS Server » Backup & Recovery » Export problem of user schema ....Urgent help needed
icon8.gif  Export problem of user schema ....Urgent help needed [message #126076] Thu, 30 June 2005 17:12 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

i am facing problem in exporting user schema ...

---> Earlier i was able to take export of this user iq7070 but now its not working so i need help ... how can i take export of this user schema now


Please see below and see what is happening when i try to export this user.
-----------------------------------------------------------------

Username: iq7070
Password:

Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > latest.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > U

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes > n

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
User to be exported: (RETURN to quit) > iq7070

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user IQ7070
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user IQ7070
About to export IQ7070's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions

EXP-00056: ORACLE error 4021 encountered
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_METADATA", line 1511
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1864
ORA-06512: at "SYS.DBMS_METADATA", line 3707
ORA-06512: at "SYS.DBMS_METADATA", line 3689
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
-----------------------------------------------------------------

Note :-[1] User iq7070 is using 300 MB space on my database.
[2] I connect to server which is remotly present and trying to export there.
[3] I am using putty to connect to my database which is remotly present.

Thanks

From:- Sunil

[Updated on: Thu, 30 June 2005 17:13]

Report message to a moderator

Re: Export problem of user schema ....Urgent help needed [message #126126 is a reply to message #126076] Fri, 01 July 2005 02:50 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

Check which objects are getting locked & kill the respective sessions, or else, if possible restart the instance and then start the export.

Regds
Girish
Re: Export problem of user schema ....Urgent help needed [message #126454 is a reply to message #126126] Mon, 04 July 2005 14:06 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Thank your very much girish ... my issue is been fixed by rebooting my server on which oracle database reside. So now i am able to take export of user schema.

From:- sunil
Previous Topic: Question abour restoring to diff. Server via RMAN
Next Topic: RMAN hot backup with no archivelogs
Goto Forum:
  


Current Time: Thu Mar 28 04:13:01 CDT 2024