import & export

[tyb]

Dear Frends

is it possible to use the import/export utility from a client machine while the DB resides on server in a workgroup.

 

[SantaMufasa]

Tyb,

As long as the client can connect to the server (with SQL*Plus, for example), you should be able to connect with (and use) imp/exp from the client, as well.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:28 (29May04) UTC (aka "GMT" and "Zulu"), 09:28 (29May04) Mountain Time)

 

[akramhammad]

I have a problem starting the export from a windows client. Iam not very experienced but looking after the database. not able to access the server due to password issues. my oracle 8i is on the server and I need to export users from my client. I can connect to db using sql plus, can you please show me what commands should I use to export my data base (full or user by user)?
thanks
Akram

 

[SantaMufasa]

Akram,

On either the client or the server machine, you should be able to issue the following export ("exp") command from an operating system command prompt:

exp buffer=15000000 compress=n feedback=1000 consistent=y file=<your_dump_file_name> log=<your_log_file_name> statistics=none owner=<schema_to_export> userid=<username>/<password>@<instance_alias>
****************************************************************************************************************************************************************************************************

You can obtain a listing of available "exp" command-line options with this command:

exp help=y

Let us know how things worked for you.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[akramhammad]

thanks for your quick reply
I tried it and got the follwoing :
invalid format of export utility name

verify that ORACLE_HOME is set properly


any help?

 

[KenCunningham]

Akram, can you verify what your ORACLE_HOME is set as?

 

[akramhammad]

this is the value in ORACLE_HOME in regedit command
c:\orant
I submitted another post a while ago, in which I mentioned that I could not find the EXP and IMP files on my PC so I copied them from the another server with 8.1.7 database.
this may help you help me.
thanks

 

[KenCunningham]

Hmm. I'm not really an Oracle-on-Windows person, but I'd confirm a)that the imp and exp utilities are exactly where Oracle expects them to be and b) That the files haven't been corrupted in the copying process (did you ftp them by any chance - if so you would have to use binary mmode not standard ASCII). I imagine you have both these matters covered, but thought I'd mention them anyway.

 

[akramhammad]

hi
the problem has been resolved.
I had to reinstall the Oracle Client on the PC.Export and Import files were copied and it worked.
of course I had to rename the old famous file SYMCJIT.DLL before installing it.
I just want to say thanks guys. no I can go home with few less things to worry about.

 

[KenCunningham]

Excellent, well done.