-
Import Error
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
-
you operation timed out and you lost connection - start again
-
Originally Posted by M.Shakeel Azeem
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
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?
-
-
If your dump is local then don't use tns
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
-
trying to create a view with dblink as reference.
try to ignore this error.
create a dblink after then.
and
manually create the view.
---------------
-
ORA-12535: TNSperation timed out
is raised due to the dblink trying to access another db.
---------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|