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

Prateek,
Sorry for the delay. Why do you need the SID? You must have (i guess) only
the default/starter database installed and the SID should  be ORCL. The
Export command ( run at the command prompt) should not ask you for the SID.
If you type EXP at the cmd prompt it will guide you through and ask you
which user/tables you want to export and give a default name to the export
file (ex*.dmp). Try and let me know if you need help.

----- Original Message -----
From: "Prateek Arora" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Sunday, March 30, 2003 2:36 AM
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].