OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01157

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

ORA-01157 [message #110510]

Tue, 08 March 2005 04:33

chandrasekhar200
Messages: 5
Registered: March 2005
Location: none

Junior Member

Hi all,

I am trying to make a dump file out of my database and have been encountering the error

. exporting tablespace definitions
EXP-00008: ORACLE error 1157 encountered
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/opt/oracle/oradata/orcl1/temp01.dbf'
EXP-00000: Export terminated unsuccessfully

The same error occurs when I try to load data using the "imp" command. Please help me out here. This is getting critical for my project.

Thanks in advance.
Chandra

Report message to a moderator

Re: ORA-01157 [message #110541 is a reply to message #110510]

Tue, 08 March 2005 09:36

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

is the temp file present .. ?

Report message to a moderator

Re: ORA-01157 [message #110593 is a reply to message #110510]

Tue, 08 March 2005 17:19

KumarD
Messages: 8
Registered: March 2005
Location: india

Junior Member

Hi,
please type the following command at SQL/SVRMGRL prompt by connecting as Sysdba

select status from v$tempfile where file#=201

if the status displayed as offline...then checkout the location of the file...confirmed whether file is there or not....

if the file is corrupted or missing and u want to avoid recovery steps then it's a file which belongs to temporary tablespace

please create a new temporary tablespace then do the export/import it will work

the problem why you got the error is Export/Import when it operates on database it needs a temporary segments from a tempfile....if that file is not available then it cannot perform it's operation

kumar

Report message to a moderator

Re: ORA-01157 [message #110595 is a reply to message #110510]

Tue, 08 March 2005 18:31

dilip kumar
Messages: 111
Registered: December 2003

Senior Member

hi

checkout the temp01.dbf file status....

Dilip

Report message to a moderator

Re: ORA-01157 [message #111042 is a reply to message #110510]

Sat, 12 March 2005 12:23

chandrasekhar200
Messages: 5
Registered: March 2005
Location: none

Junior Member

Hi KumarD,

God bless you man! It worked. I had to make a tablespace, make it the default temp. tablespace and then drop the first temporary tbspace. It worked then. Thanks once more.

I almost lost faith in message boards@!!!

Report message to a moderator

Re: ORA-01157 [message #111051 is a reply to message #111042]

Sat, 12 March 2005 15:22

KumarD
Messages: 8
Registered: March 2005
Location: india

Junior Member

Hi,

Good to know that your issue has resolved....

"Never Loose a Faith on Anything"

Regards

Kumar

Report message to a moderator

Previous Topic:	how to find size of each table in db
Next Topic:	URGENT PLZZZZZZ

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 10:56:14 CDT 2024