20120326 04:25:26
--GetSqlDataTable--
select biaom from (select biaom,zidm
from (select biaom,
zidm,
zhuj,
leix,
changd,
xiaoshwsh,
yunxk,
morzh,
zidshm
from (select a.table_name biaom,
a.column_name zidm,
a.data_type leix,
a.data_length changd,
0 xiaoshwsh,
a.nullable yunxk,
a.data_default morzh,
b.comments zidshm
from user_tab_cols a, user_col_comments b
where a.table_name = b.table_name
and a.column_name = b.column_name) p
left join (select column_name, m.table_name, m.constraint_name zhuj
from user_constraints m, user_cons_columns n
where m.table_name = n.table_name
and m.constraint_name = n.constraint_name
and m.constraint_type = 'P') q
on p.biaom = q.table_name
and q.column_name = p.zidm)
group by biaom,zidm
order by biaom,zidm) group by biaom order by biaom
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
在 TPCClass.AbstractDB.GetSqlDataTable(String strSql)
关键字 'group' 附近有语法错误。
--GetSqlDataTable End--
20120326 08:44:26
--GetSqlDataTable--
select LINE_NO,OBJECT_NAME,OBJECT_TYPE,SQL_TEXT,USER_NAME from BIN$2H1I7hqeSyudg9CzIXT9XQ==$0
在 System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
在 System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
在 TPCClass.AbstractDB.GetSqlDataTable(String strSql)
ORA-00933: SQL 命令未正确结束
--GetSqlDataTable End--
20120326 11:09:26
--GetSqlDataTable--
select * from systypedsubobjs
在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
在 TPCClass.AbstractDB.GetSqlDataTable(String strSql)
对象名 'systypedsubobjs' 无效。
--GetSqlDataTable End--
20120326 11:24:26
--GetSqlDataTable--
select LINE_NO,OBJECT_NAME,OBJECT_TYPE,SQL_TEXT,USER_NAME from BIN$wtE2ZacuSeCkNOCDJKzJrg==$0
在 System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
在 System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
在 System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
在 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand com
sql+oracle 数据库脚本备份及重要表数据批量导出
4星 · 超过85%的资源 需积分: 50 14 浏览量
2012-03-26
16:30:21
上传
评论 1
收藏 26.4MB RAR 举报 
Debug120326-02.rar （41个子文件） 
Debug 
orannzsbb10.dll 1.05MB DevComponents.DotNetBar.Design.dll 372KB TPCClass.dll 149KB log 
SQL_Error_20120326.txt 9KB error_20120326.txt 146B glogin.sql 1KB oci.dll 344KB Images 
view.gif 897B table.gif 960B Procedure.gif 945B other1.gif 885B file.gif 1003B other3.gif 885B fn.gif 902B other2.gif 907B data.gif 147B source.gif 173B ocijdbc10.dll 76KB DevComponents.DotNetBar2.dll 3.96MB Orasqlplusic10.dll 1.57MB SQLUtil.vshost.exe.manifest 490B
SQLUtil.exe 94KB SQLUtil.vshost.exe 11KB
ojdbc14.jar 1.48MB 注册SQLDMO.bat 987B Interop.SQLDMO.dll 928KB BASIC_README 315B user_ddl_sql.sql 123KB sqlplus.exe 548KB oraociei10.dll 87.35MB SQLDMO.RLL 572KB SQLDMO.DLL 4.35MB classes12.jar 1.54MB SQLUtil.pdb 102KB global.xml 902B sqlnet.log 2KB SQLPLUS_README 319B tnsnames.ora 2KB CreateDir.bat 1004B ociw32.dll 336KB oraocci10.dll 756KB资源评论
strive_bo2012-04-04很好，但是是。net的
