-
编辑 删除
drop database
drop database[@more@]今天手动建库，正执行catproc 脚本，突然停电了。悲催呀。需要重新删除库重建。在oracle 10g里，有一条新特性是使用drop database命令可以删除数据库的数据文件，联机日志文件，控制文件，spfile.使用drop database命令需要以下三个条件：database moust be closedexclusively mountedrestricted mode下面是实验的过程:Enter user-name: / as sysdbaConnected to an idle instance.SQL> startup;ORACLE instance started.Total System Global Area 314572800 bytesFixed Size 1248720 bytesVar
-
编辑 删除
oracle 11g r2 install
oracle 11g release 2 install for linux as 5 x64[@more@]1.安装检查准备查看内存、SWAP空间、硬盘空间、CPU情况。grep MemTotal /proc/meminfogrep SwapTotal /proc/meminfoBetween 1 GB and 2 GB 1.5 times the size of RAM Between 2 GB and 16 GB Equal to the size of RAM More than 16 GB 16 GB The following or later versions of the operating system are required for Oracle Database 11g Release 2 (11.2):•Asianux 2•Asianux 3•Oracle Enterprise Linux 4 Update 7•Oracle Enterprise Linux 5 Upd
