麻烦提供下载，或者发到我邮箱paulyi.good@163.com非茶感谢在网上找了个，解压密码不对　用不了

sqlserver 我存的时间字段为字符型，我想转为datetime怎么转'2008-01-14 15:34:35.187000000'select cast('2008-01-14 15:34:35.187000000' as datetime) abc报错请问怎么解决

如何用sql从mssql中查出某个存储过程里面的原码

比如,我有个存储过程在某个库上,我想查询下这个存储过程赋予了哪些用户的执行权限想从系统表中查出来请问是哪个系统表?

版本oracle_9.2.0.4+winxp[php]C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jan 9 11:44:27 2008Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - ProductionSQL> create table test as select 1 id,'Y' flag from dba_objects where rownum insert i

在看rman操作文档RMAN> CATALOG DATAFILECOPY '/dk2/oradata/trgt/users01.dbf'; # catalog split mirror和RMAN> CHANGE DATAFILECOPY '/dk2/oradata/trgt/users01.dbf' UNCATALOG;是什么意思

在rman 中backup database 加上force 参数,起什么作用看文档没看明白

SQL> show parameter log_archive_min;NAMETYPEVALUE------------------------------------ ----------- ------------------------------log_archive_min_succeed_destinteger2这个怎么理解确定归档至少要有几个成功的主要怎么应用,能否举个例子加深理解

dataguardV$ARCHIVE_GAP视图怎么理解怎么样才能让这个视图产生数据?

When you rename one or more datafiles in the primary database, the change is notpropagated to the standby database. Therefore, if you want to rename the samedatafiles on the standby database, you must manually make the equivalentmodifications on the standby database because the modifications are not performedautomatically, even if the STANDBY_FILE_MANAGEMENT initialization parameter isset to AUTO.意思是说 在主库上对某个表空间的数据文件改名,同样对备库的数据文件也要改名 即使standby_

For example, to ensure that the primary database never accidentally receives anyarchived redo logs, you can set the REMOTE_ARCHIVE_ENABLE initializationparameter to SEND on the primary database. Conversely, to ensure that the standbydatabase never remotely archives the standby redo logs, you can set the REMOTE_ARCHIVE_ENABLE initialization parameter to RECEIVE on the standby database.请问设置以上这两个参数时怎么理解

Enable Dead Connection Detection on the Standby SystemEnable dead connection detection by setting the SQLNET.EXPIRE_TIME parameterto 2 in the SQLNET.ORA parameter file on the standby system. For example:SQLNET.EXPIRE_TIME=2设置以上这个起什么作用?

借这里人气问一下RT

RT

SQL> show parameter log_archive;NAMETYPEVALUE------------------------------------ ----------- ----------------------------log_archive_deststringlog_archive_dest_1stringlocation=d:\oralog_archive_dest_10stringlog_archive_dest_2stringservice=standby mandatory reopen=60SQL> select protection_mode from v$database;PROTECTION_MODE-----------------

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?An appropriated answer is respected!!!

SQL> select force_logging from v$database;FOR---YES用什么命令更改force_logging 为 no

控制文件内容如下;LOAD DATA INFILE 'F_DEP_SAE_EVT.txt'BADFILE 'F_DEP_SAE_EVT.bad'TRUNCATE INTO TABLE F_DEP_SAE_EVTFIELDS TERMINATED BY "|"TRAILING NULLCOLS(ODS_1ST_LEV_BR_NONULLIF ODS_1ST_LEV_BR_NO='\\N',ODS_SRC_DTNULLIFODS_SRC_DT='\\N',CCBS_ACCT_NONULLIFCCBS_ACCT_NO='\\N',CUST_ACCT_NONULLIFCUST_ACCT_NO='\\N',SA_CUST_NONULLIFSA_CUST_NO='\\N',ECIF_CUST_NONULLIFECIF_CUST_NO='\\N',SA_ACCD_CODNULLIFSA_ACCD_COD='\\

请问在oracle 中如何实现两个时间相减得分钟的sql