Home » Developer & Programmer » Forms » exporting & importing
exporting & importing [message #193178] Fri, 15 September 2006 03:10 Go to next message
jai_162
Messages: 21
Registered: July 2006
Junior Member
can u provide me syntax of exporting & importing a datadase in unix
regrds
jp
Re: exporting & importing [message #193181 is a reply to message #193178] Fri, 15 September 2006 03:15 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
the syntax for IMP and EXP is the same on all OS's if i am not wrong.

that is on the command line

$ EXP parameters.

$ IMP parameters.

Liza
Re: exporting & importing [message #193186 is a reply to message #193181] Fri, 15 September 2006 03:34 Go to previous messageGo to next message
jai_162
Messages: 21
Registered: July 2006
Junior Member
I need to export a db called insdev

using the following script :
exp scott/tiger1@insosdev table=tbso_register file=ins.dmp log=ins.log owner=insos constraints=y indexes=y

Received the following error:
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully

Let me know how to go abt?
Regards
JP
Re: exporting & importing [message #193233 is a reply to message #193186] Fri, 15 September 2006 06:50 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
what are you logged in as?
i think you need to configure your tnsnames.ora
Re: exporting & importing [message #193702 is a reply to message #193233] Tue, 19 September 2006 01:17 Go to previous messageGo to next message
jai_162
Messages: 21
Registered: July 2006
Junior Member
But iam not sure how to find in tnsnames.ora in Unix.Let me know regarding the same.

Can you also provide the synatx of export & import to perform in Unix.
Re: exporting & importing [message #193721 is a reply to message #193702] Tue, 19 September 2006 02:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There must be some kind of a search utility/command on Unix; is it "search", "dir" or "ls", I don't know, but I'm sure it exists somewhere.

TNSNAMES.ORA *should* be in the \network\admin subdirectory of your Oracle directory.

Import and Export *should* have the same command lines, independant of operating system. The easiest way to see it is to run EXP HELP=Y (the same goes for IMP). If this doesn't help, check Oracle Utilities Manual for OS you use (Unix).
icon4.gif  Re: exporting & importing [message #193734 is a reply to message #193186] Tue, 19 September 2006 03:35 Go to previous message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

HI

If you are on the computer which is database server then
there is no need to specify connect string.

try this

it will work i hope!!!!!

regards

Muhammad Shahid Mughal
Faisalabad Pakistan
Previous Topic: HOW TO DISPLAY THE REPORT
Next Topic: fetching records
Goto Forum:
  


Current Time: Fri Dec 09 15:42:09 CST 2016

Total time taken to generate the page: 0.15374 seconds