Home » RDBMS Server » Server Administration » Import Error
Import Error [message #221332] Mon, 26 February 2007 06:24 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
i am getting the error while i am trying to import schema into test Db server
Can anybody help me in this regard?

"CREATE FORCE VIEW "NCTEXMIS"."VEW_ERP_COUNTRY"
"NTRY_CODE","COUNTRY_NAME") AS "
"select C.COUNTRY_ID AS COUNTRY_CODE,"
" C.COUNTRY_DESC AS COUNTRY_NAME"
" from WIZ_COUNTRY_MT@NCTEXTOERP C"
"WITH READ ONLY"
IMP-00003: ORACLE error 12535 encountered
ORA-12535: TNSperation timed out
Re: Import Error [message #221333 is a reply to message #221332] Mon, 26 February 2007 06:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ORA-12535: TNSperation timed out

ping your server ip address ?
reply or request timeout. what you get...

Disable your firewall setting.


regards
Taj
Re: Import Error [message #221351 is a reply to message #221333] Mon, 26 February 2007 07:47 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Mohammad Taj wrote on Mon, 26 February 2007 06:33
Hi,
ORA-12535: TNSperation timed out

ping your server ip address ?
reply or request timeout. what you get...

Disable your firewall setting.


regards
Taj


i have copied dump file on my test Db server where i want to import it ,this machine is up and running and Db services are also running
So what could be the reason now?
Re: Import Error [message #221363 is a reply to message #221351] Mon, 26 February 2007 08:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Go through below link
http://www.dbmotive.com/oracle_error_codes.php?errcode=12535



hope this helps
Taj
Previous Topic: drop user cascade
Next Topic: Inteview Questions
Goto Forum:
  


Current Time: Mon Dec 02 15:51:22 CST 2024