$HOSTNAME:$ORACLE_SID(DB)$PWD>exp babub/babu file=31736.dmp tables=TE.te_mth_dbase_inv_bal_all 
Query = \" WHERE item_id BETWEEN \1\ and \999999999999\ and LTRIM (RTRIM (MONTH)) = \'AUGUST'\ AND YEAR = \'2008'\"

syntax error: `(' unexpected

SQL> SELECT count(creation_date)
FROM TE.te_mth_dbase_inv_bal_all
WHERE item_id BETWEEN 1 AND 999999999999
AND LTRIM (RTRIM (MONTH)) = 'AUGUST'
AND YEAR = '2008'

$HOSTNAME:$ORACLE_SID(DB)$PWD>exp babub/babu file=31736.dmp tables=TE.te_mth_dbase_inv_bal_all 

Query = \" WHERE item_id BETWEEN (1) and (999999999999) and \'LTRIM (RTRIM (MONTH))'\ = \'AUGUST'\ AND YEAR = \'2008'\"
syntax error: `(' unexpected

$HOSTNAME:$ORACLE_SID(DB)$PWD>syntax error: `TRIM' unexpected

$HOSTNAME:$ORACLE_SID(DB)$PWD>exp babub/babu file=31736.dmp tables=TE.te_mth_dbase_inv_bal_all 
Query = \" WHERE item_id BETWEEN \1\ and \999999999999\ and \'LTRIM (RTRIM (MONTH))\' = \'AUGUST\' AND YEAR = \'2008\'"
syntax error: `(' unexpected

SQL> SQL> SELECT count(creation_date)
FROM te.te_mth_dbase_inv_bal_all
WHERE item_id BETWEEN 1 AND 999999999999
AND LTRIM (RTRIM (MONTH)) = 'AUGUST'
AND YEAR = '2008'  2    3    4    5
  6  /

COUNT(CREATION_DATE)
--------------------
               40453

SQL> !
$HOSTNAME:$ORACLE_SID($ORACLE_ENV)$PWD>exit

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ne-ocadb01:DP100(DB)/global/DIS/ENVAP/oracle/db/9.2.0>exp babub/babu file=31736.dmp tables=(TE.TE_MTH_DBASE_INV_BAL_ALL)
 Query = \" WHERE item_id BETWEEN \1\ and \999999999999\ and \'LTRIM\'\'RTRIM\'\'MONTH\' = \'AUGUST\' AND YEAR = \2008\" statistics=none

Export: Release 9.2.0.6.0 - Production on Tue Sep 23 17:37:55 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to TE
. . exporting table       TE_MTH_DBASE_INV_BAL_ALL          0 rows exported
Export terminated successfully without warnings.

\" WHERE item_id BETWEEN 1 and 999999999999 and LTRIM \(RTRIM \(MONTH\)\) = 'AUGUST' AND YEAR = '2008'\"

ne-ocadb01:DP100(DB)/global/DIS/ENVAP/oracle/db/9.2.0>exp babub/babu file=31736.dmp tables=(TE.TE_MTH_DBASE_INV_BAL_ALL) 

Query = \" WHERE item_id BETWEEN 1 and 999999999999 and LTRIM \(RTRIM \(MONTH\)\) = 'AUGUST' AND YEAR = '2008'\"

Export: Release 9.2.0.6.0 - Production on Tue Sep 23 18:05:12 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to TE
. . exporting table       TE_MTH_DBASE_INV_BAL_ALL
EXP-00056: ORACLE error 904 encountered
ORA-00904: "AUGUST": invalid identifier
Export terminated successfully with warnings.

Query = \" WHERE item_id BETWEEN 1 and 999999999999 and LTRIM \(RTRIM \(MONTH\)\) = \'AUGUST\' AND YEAR = '2008'\"

Export: Release 9.2.0.6.0 - Production on Tue Sep 23 18:05:58 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to TE
. . exporting table       TE_MTH_DBASE_INV_BAL_ALL      40453 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

\" WHERE item_id BETWEEN 1 and 999999999999 and LTRIM \(RTRIM \(MONTH\)\) = \'AUGUST\' AND YEAR = \'2008\'\"