Re: How can I Export/Import a single or multiple tables from/to Oracle 8 for windows95?
"manit_jain" <[email protected]> Mon, 31 Mar 2003 12:50:37 +0530
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-933835-2003.03.31-08.16.38--gcdod-oracle#[email protected]> |
the ORACLE_SID is the name of the oracle service you are using.if you are using Oracle8.0 then it would be orcl.Also in order to run imp/exp the classpath must be set to %ORACLE_HOME%/bin directory. if it is not set then go to prompt c:\orawin95\bin:\> then type exp. also to export/import you must log on with DBA previleges.try it with system/manager account or grant the DBA role to the user through which you want to import the data. regards. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now ! --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].