OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » export problem

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

export problem [message #63055]

Mon, 06 September 2004 06:42

jack
Messages: 123
Registered: September 2000

Senior Member

I wanted to export a user from system tablespace.

The command I used was:

exp u01/u01password@produce file=u01.dmp log=u01.log

The error was:

EXP-00056: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_LOB", line 424
ORA-06512: at "SYS.DBMS_METADATA", line 1140
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
�How do I fix it?
Thanks in advance!

Jack

Report message to a moderator

Re: export problem [message #63056 is a reply to message #63055]

Mon, 06 September 2004 08:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please make sure u have a temp tablespace

Report message to a moderator

Re: export problem [message #63057 is a reply to message #63056]

Mon, 06 September 2004 10:35

jack
Messages: 123
Registered: September 2000

Senior Member

You are right. After I added temp file. Everything is ok. But I am wondering that I didn't do anything with temp file. While it is lost?

Thanks

Report message to a moderator

Re: export problem [message #63058 is a reply to message #63057]

Mon, 06 September 2004 11:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

might be of any reason.
first, is this database been restored/duplicated with RMAN?. RMAN will not backup/restore TEMP tablespace.

Report message to a moderator

Previous Topic:	Dbms_flashback can not retrieve dropped tables?
Next Topic:	10g installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 04:00:08 CST 2025