Re: How can I Export/Import a single or multiple tables from/to Oracle 8 for windows95?

At command prompt type:

C:\>SET ORACLE_SID=MYDB   (where MYDB is the name of your database)
C:\>EXP

(you will probably just want to export one user, don't specify any tables to 
copy all of them)

do same on your friends PC but use run

C:\>SET ORACLE_SID=MYDB   (where MYDB is the name of their database)
C:\>IMP

Regards,

Darren Collard



>From: Prateek Arora <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] Re: How can I Export/Import a single or multiple tables 
>from/to Oracle 8 for windows95?
>Date: Sat, 29 Mar 2003 07:20:09 -0800 (PST)
>
>
>Hi!,
>    Thanks for replying! No no, i do not directly want export from my PC to 
>my friends PC. I actually want to know how to create a .dmp file in my PC 
>and then I'll email him the file and he will then Import it into his oracle 
>database.
>      Hence I want to know how to Export and Import a file into/from .dmp 
>file. Please reply ASAP.
>Thanking You,
>Prateek Arora
>  Sanjay Raj <[email protected]> wrote:
>You will do an export from yr machine and import the .dmp file into yr 
>friend's machine. You may have to do a FROMUSER to TOUSER in the import 
>parameter - maybe not
>Prateek Arora
>wrote:Hi!,
>I want to take backup of my tables and then Import them into my friends
>computer. We are both using Oracle 8 for Windows 95 and not Oracle 8i. Any
>help ASAP would be really appreciated.
>
>Thanking You,
>
>Yours Faithfully,
>
>Prateek Arora
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.


_________________________________________________________________
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].