log for transaction

2003-06-24 Thread jinchen
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 Se

RE: got EXP-00091 warning

2003-06-21 Thread jinchen
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

2003-06-20 Thread jinchen
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

2003-06-17 Thread jinchen
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 > whe

How to stop script

2003-06-16 Thread jinchen
I have a script and can be run on commandline like: > sqlplus /@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 database? In impor