Re: what is wrong with this export?

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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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: jan_at_pruner.cz

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: ListGuru_at_fatcity.com (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: rafiq9857_at_hotmail.com

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: ListGuru_at_fatcity.com (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).