oracle issue
Yes, sure ! You must be the local admin of this computer, and not a domain user.
Moreover, I'm afraid you cannot install it in a domain, maybe you should (just for testing purposes) try to install a standalone Windows system and try installing Oracle 10g on it.
You know, a RDBMS database server must be installed on a server system. You can cheat, installing it on a standalone Windows system, the standalone system emulating a server. But I'm even not sure you can install it on a client machine. Oracle server is traditionally installed on server systems, and Oracle client is installed on client system.
Please, keep us informed, if you were successful loggin on your own system as localsystem administrator, and if you were then able to correctly install Oracle.
If not, I strongly suggest you to restart everything from scratch (even on an old machine) just for learning purposes. After installing on a brand new Windows standalone system, you will feel more confident for installing it on your client system.
Regards
Yordan
相关文档：
一、 常用日期数据格式
1.Y或YY或YYY 年的最后一位，两位或三位
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_char(sysdate,'YYY') from ......
经常用到的数据库导入导出，每次用都要查询，把语句保留在这边方便以后查阅
//快速导入数据到另一个数据库的语句
例如：
imp tms/tms@TMS_192.168.0.104 file=c:\1.dmp buffer=30720 show=no ignore=yes grants=yes rows=yes full=yes
路径为Oracle路径
imp tms/tms@TMS file=d:\tmsbf_all.dmp buffer=30720 show=no ......
背景：在windows 2003 server上安装了Oracle 9.2.0.1.0，现打算将其升级到9.2.0.8版本。
1.升级oracle（administrator用户权限）
(1)到metalink下载升级压缩包，patch号为4547809，压缩包名称为 p4547809_92080_WINNT.zip，for windows 32bit。
(2)解压缩zip，下边包含一个Disk1和readme.html文件。 ......
在对数据库进行操作过程中我们可能会遇到这种情况，表中的数据可能重复出现，使我们对数据库的操作过程中带来很多的不便，那么怎么删除这些重复没有用的数据呢?
重复数据删除技术可以提供更大的备份容量，实现更长时间的数据保留，还能实现备份数据的持续验证，提高数据恢复服务水平，方便实现数据容灾等。 重复的数� ......
类型名称
Oracle
SQLServer
比较
字符数据类型
CHAR
CHAR
都是固定长度字符资料但oracle里面最大度为2kb，SQLServer里面最大长度为8kb
变长字符数据类型
VARCHAR2
VARCHAR
Oracle里面最大长度为4kb，SQLServer里面最大长度为8kb
根据字符集而定的固定长度字符串
NCHAR
NCHAR
前者最大长度2kb后者最大长度4 ......
