https://blog.youkuaiyun.com/knitysterzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/knityster/article/details/6323221https://blog.youkuaiyun.com/knityster/article/details/6323221knitysterThu, 14 Apr 2011 15:04:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6323188https://blog.youkuaiyun.com/knityster/article/details/6323188knitysterThu, 14 Apr 2011 14:51:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317417https://blog.youkuaiyun.com/knityster/article/details/6317417knitysterTue, 12 Apr 2011 10:38:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317414https://blog.youkuaiyun.com/knityster/article/details/6317414knitysterTue, 12 Apr 2011 10:36:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317408https://blog.youkuaiyun.com/knityster/article/details/6317408knitysterTue, 12 Apr 2011 10:35:00 +0800 select * from v$logfile;       GROUP# STATUS  TYPE    MEMBER ---------- ------- ------- ----------------------]]>https://blog.youkuaiyun.com/knityster/article/details/6317404https://blog.youkuaiyun.com/knityster/article/details/6317404knitysterTue, 12 Apr 2011 10:34:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317401https://blog.youkuaiyun.com/knityster/article/details/6317401knitysterTue, 12 Apr 2011 10:33:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317392https://blog.youkuaiyun.com/knityster/article/details/6317392knitysterTue, 12 Apr 2011 10:30:00 +0800sqlplus scott/tiger2. 以DBA登录对于10g：C:/>sqlplus sys/manager as sysdba但是对于9i,以上写法无效，应该使用：C:/>sqlplus sys/manager@“oracle as sysdba"   注意引号其中的oracle为本地Oracle数据库SID二。远端Oracle其中的oracle_192.168.2.1为本地Oracle数据库SID1. 普通账户C:/>sqlplus scott/tiger]]>https://blog.youkuaiyun.com/knityster/article/details/6317386https://blog.youkuaiyun.com/knityster/article/details/6317386knitysterTue, 12 Apr 2011 10:29:00 +0800 exp bbs/password file=/home/oracle/bbs.dmp owner=bbs;> imp bbs/password file=/home/oracle/bbs.dmp fromuser=bbs;   出现错误： failed to open ......for write/reader   原因： oracle 账户没有对指定目录的读/写权限   解决办法： 更换到Oracle有读写权限的相关目录]]>https://blog.youkuaiyun.com/knityster/article/details/6317333https://blog.youkuaiyun.com/knityster/article/details/6317333knitysterTue, 12 Apr 2011 10:15:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317329https://blog.youkuaiyun.com/knityster/article/details/6317329knitysterTue, 12 Apr 2011 10:14:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317318https://blog.youkuaiyun.com/knityster/article/details/6317318knitysterTue, 12 Apr 2011 10:10:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317313https://blog.youkuaiyun.com/knityster/article/details/6317313knitysterTue, 12 Apr 2011 10:09:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317308https://blog.youkuaiyun.com/knityster/article/details/6317308knitysterTue, 12 Apr 2011 10:06:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317303https://blog.youkuaiyun.com/knityster/article/details/6317303knitysterTue, 12 Apr 2011 10:05:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317294https://blog.youkuaiyun.com/knityster/article/details/6317294knitysterTue, 12 Apr 2011 10:03:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317289https://blog.youkuaiyun.com/knityster/article/details/6317289knitysterTue, 12 Apr 2011 10:01:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317285https://blog.youkuaiyun.com/knityster/article/details/6317285knitysterTue, 12 Apr 2011 10:01:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317284https://blog.youkuaiyun.com/knityster/article/details/6317284knitysterTue, 12 Apr 2011 10:00:00 +0800https://blog.youkuaiyun.com/knityster/article/details/6317280https://blog.youkuaiyun.com/knityster/article/details/6317280knitysterTue, 12 Apr 2011 09:59:00 +0800