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

Hi,
   Thank you for replying. But how do I find out what is the name of my database? Is it same as my login name like SCOTT whose password is TIGER? I tried your method with the above login name i.e. at command prompt, I typed C:\>SET ORACLE_SID=SCOTT and then when I typed EXP at command prompt, it says BAD COMMAND OR FILE NAME.
                    Let me explain you my problem. I have 5 tables in the user SCOTT. I want to give these tables to my friend. Hence, I want to export these tables into a file, email the file(s) to my friend, and he will then import these in his database. The problem is how to export and then import, to or from a file. It doesn't matter whether all the tables (other then the required 5 tables also) are copied into the exported file or each table is to be exported indivisually. I just want to know how to go about it. I would really appreciate it very much if you could please help me in this regard.
          Thanking You,
Regards,
Prateek
 
 Darren Collard <[email protected]> wrote: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 

>Reply-To: "Oracle" 
>To: "Oracle" 
>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 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.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 protected].