log for transaction

Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network

RE: got EXP-00091 warning

Thanks Dennis, I wonder if I can find whether or not there is any problem in that schema, because that could be any of those a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were

got EXP-00091 warning

Greetings, When I export schema containing some tables, I got EXP-00091 warnings. The log is saying: .. JServer Release 9.2.0.1.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) . exporting

Re: How to stop script

Thanks! That's exactly what I need! Jin Quoting Pete Finnigan [EMAIL PROTECTED]: Hi You can stop the script by using the line whenever sqlerror exit rollback and then generating an error by using an exception in a PL/SQL block as follows: oracle:jupiter cat imp.sql whenever

How to stop script

I have a script and can be run on commandline like: sqlplus usrname/password@TEST @import.sql However, I want to check database name at the beginning of import.sql. I knew select name from v$database can obtain database name. But how can I stop the script if I found it is not TEST