OraFAQ Forum: Forms » exporting & importing

Home » Developer & Programmer » Forms » exporting & importing

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

exporting & importing [message #193178]

Fri, 15 September 2006 03:10

jai_162
Messages: 21
Registered: July 2006

Junior Member

can u provide me syntax of exporting & importing a datadase in unix
regrds
jp

Report message to a moderator

Re: exporting & importing [message #193181 is a reply to message #193178]

Fri, 15 September 2006 03:15

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

Report message to a moderator

Re: exporting & importing [message #193186 is a reply to message #193181]

Fri, 15 September 2006 03:34

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

Report message to a moderator

Re: exporting & importing [message #193233 is a reply to message #193186]

Fri, 15 September 2006 06:50

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

Report message to a moderator

Re: exporting & importing [message #193702 is a reply to message #193233]

Tue, 19 September 2006 01:17

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.

Report message to a moderator

Re: exporting & importing [message #193721 is a reply to message #193702]

Tue, 19 September 2006 02:32

Littlefoot
Messages: 21818
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).

Report message to a moderator

Re: exporting & importing [message #193734 is a reply to message #193186]

Tue, 19 September 2006 03:35

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

Report message to a moderator

Previous Topic:	HOW TO DISPLAY THE REPORT
Next Topic:	fetching records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:43:37 CDT 2024