bash error

[srikanth4403]

hi all,

i am trying to take backup of oracle tables by using exp command but when i am entering the command it is giving a error as below
bash: syntax error near unexpected token `('

So kindly someone tell me how to rectify this and proceed for the normal export.

The original command what iam typing is

exp username/password@sid file=filename.dmp log=filename.log tables=(all table names separated by comma) indexes=n grants=n direct=true

[Dave Korn]

On 16 April 2007 08:40, srikanth4403 wrote:

> hi all,
>
> i am trying to take backup of oracle tables by using exp command but when i
> am entering the command it is giving a error as below
> bash: syntax error near unexpected token `('
>
> So kindly someone tell me how to rectify this and proceed for the normal
> export.
>
> The original command what iam typing is
>
> exp username/password@sid file=filename.dmp log=filename.log tables=(all
> table names separated by comma) indexes=n grants=n direct=true

  I think you're supposed to replace the text "(all table names separated by
comma)" with a list of all the database tables you want to query separated by
commas, rather than enter it literally.


    cheers,
      DaveK
--
Can't think of a witty .sigline today....


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

[Carlo Florendo-2]

srikanth4403 wrote:
> hi all,
>
> i am trying to take backup of oracle tables by using exp command but when i
> am entering the command it is giving a error as below
> bash: syntax error near unexpected token `('
>
> So kindly someone tell me how to rectify this and proceed for the normal
> export.


Yes.  Please use the "automatic_backup" command, passing the table names as
arguments, without parentheses, of course.

If that does not work, you may have to call oracle for tech support.

Thanks!


--
Carlo Florendo
Softare Engineer/Network Co-Administrator
Astra Philippines Inc.
UP-Ayala Technopark, Diliman 1101, Quezon City
Philippines
http://www.astra.ph

--
The Astra Group of Companies
5-3-11 Sekido, Tama City
Tokyo 206-0011, Japan
http://www.astra.co.jp

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

[Luukkanen Tapio]

This is just a basic bourne shell issue.
Examine the output of the following commands in
your cygwin's bash-window and make the necessary
changes to your "exp" command line:

bash$  echo foo=(bar,baz)
bash$  echo "foo=(bar,baz)"
bash$  echo foo="(bar,baz)"
bash$  echo foo="("bar,baz")"


-----Original Message-----
From: cygwin-owner@... [mailto:cygwin-owner@...] On Behalf
Of srikanth4403
Sent: Monday, April 16, 2007 10:40 AM
To: cygwin@...
Subject: bash error



hi all,

i am trying to take backup of oracle tables by using exp command but
when i am entering the command it is giving a error as below
bash: syntax error near unexpected token `('

So kindly someone tell me how to rectify this and proceed for the normal
export.

The original command what iam typing is

exp username/password@sid file=filename.dmp log=filename.log tables=(all
table names separated by comma) indexes=n grants=n direct=true
--
View this message in context:
http://www.nabble.com/bash-error-tf3582836.html#a10011526
Sent from the Cygwin Users mailing list archive at Nabble.com.


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

[raj8646]

If not already solved try to escape brackets

e.g

exp username/password@sid file=filename.dmp log=filename.log tables\=\(all table names separated by comma\) indexes=n grants=n direct=true

srikanth4403 wrote:

hi all,

i am trying to take backup of oracle tables by using exp command but when i am entering the command it is giving a error as below
bash: syntax error near unexpected token `('

So kindly someone tell me how to rectify this and proceed for the normal export.

The original command what iam typing is

exp username/password@sid file=filename.dmp log=filename.log tables=(all table names separated by comma) indexes=n grants=n direct=true