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

If your using Oracle 8, try exp80 and imp80 commands.

-----Original Message-----
From: Prateek Arora [mailto:[email protected]] 
Sent: Sunday, March 30, 2003 1:37 AM
To: Oracle
Subject: [oracle] 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.unsub%%.



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