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

Hi!
  Thank you all for helping me solve this problem. I really appreciate it very much. I also took help from a webpage resource in this regard and I would like to share it with you all so that you may also benefit from it. The URL is :- http://www.ora.com/faqiexp.htm.
Regards,
Prateek
 
 Darren Collard <[email protected]> wrote:The database may be called ORCL, what name do you you specify when you log 
in? you should specify username, password and database name.

If it is not EXP, it will be something beginning with EXP, have a look in 
the \BIN directory under the main ORACLE folder at files with a .EXE 
extension.

Regards,

Darren.



>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 22:36:54 -0800 (PST)
>
>
>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 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%%.


_________________________________________________________________
Surf together with new Shared Browsing 
http://join.msn.com/?page=features/browse&pgmarket=en-gb&XAPID=74&DI=1059


---
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! Tax Center - File online, calculators, forms, and more

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