Raghu Still do you want to send your export dmp to tape or on disk. Much better to study Oracle Utilities Manual for complete understanding. For short type exp (or imp) help=y <enter> on unix prompt and you will find all options available with your oracle release.
To export on tape (for 7.3.4) exp user/passwd file=/dev/tape tables=(table1,table2,table3) compress=n direct=y <enter> on disk: exp user/passwd file=/tmp/raghu.dmp tables=(table1,table2,table3) compress=n direct=y Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 30 Apr 2002 11:53:44 -0800 I'm not working on AIX, but I use syntax exp user/passwd tables=(TABLE1,TABLE2) ... etc. Why do you use \( and \) ? JP On Tue 30. April 2002 21:38, you wrote: > Hi friends, > > Iam exporting some of tables, but keep getting error!! Could you help.. > Mine is AIX415 with oracle4.3, If I want import an individual table, what > is correct form of parameters? > > exp user/passwd tables = \ ( table1, tab2, tab3, > tab40,tab5,ttdsls051061,ttdsls051110,ttdsls051120,ttdsls051130, > ttdinv700040,ttdinv700061,ttdinv700110,ttdinv700120,ttdinv700130, > ttfgld410210,ttfgld421010,ttfgld410060,ttfgld100010,ttfgld106060, > ttfgld106100\ ) COMPRESS=N direct=Y log=fullsls.log file=fullsls.dmp > > > Thanks in advance > Raghu. > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
