problem with export
Date: 11 Mar 2003 22:25:25 -0800
Message-ID: <ff46df6e.0303112225.286ae102_at_posting.google.com>
FILE=TRY.DMP TABLES=TEST QUERY=\"WHERE A\<30\"
i AM HAVING A ORACLE8I DATABASE.
I am trying to export selected rows from a table A (having an
attribute b(number))using exp command and query keyword.
i am executing the following command (exporting rows of table a whose
b attribute is <30)
exp scott/tiger tables=a file=try.dmp query=\"where b\<30\"
But i am getting the following error
EXP 00056: Oracle error 911 encountered
ora 00911: Invalid character
export terminated successfully with warnings.
for the above EXP command if i use a parameter file param.txt which contains the following statement
file=try.dmp tables=a query=\"where b\<30\"
and try to execute the exp command as below exp scott/tiger parfile=param.txt
i am getting the following error
LRM-00112: Multiple values not allowed for parameter 'query' LRM-00113: error when processing file 'param.txt' EXP-00019: Failed to process parameters, type 'EXP HELP=Y' for help EXP-00000: Export terminated unsuccessfully
what is the problem and give solution?
where can i get cause and solution for the error numbers?
Received on Wed Mar 12 2003 - 07:25:25 CET