查看当前状态[oracle@test ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 17 22:35:33 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitionin...【阅读全文】
http://docs.oracle.com/cd/B28359_01/install.111/b32002/pre_install.htm#LADBI2722 Oracle Database Preinstallation RequirementsThis chapter describes the tasks that you must complete before you start Oracle Universal Installer. It includes information about the following tasks:Note...【阅读全文】
在Red Hat As6上安装11.2.0.1时候,执行root.sh脚本,遇到的错误如下Adding daemon to inittabCRS-4124: Oracle High Availability Services startup failed.CRS-4000: Command Start failed, or completed with errors.ohasd failed to start: Inappropriate ioctl for deviceohasd failed to start at /u01/app/grid...【阅读全文】
一、使用create table as select * from table_name;缺点:无法把默认值,索引等一同迁移过来。SQL> select t.owner,t.index_name,t.index_type,t.table_owner,t.uniqueness,t.tablespace_name from dba_indexes t where t.owner='SCOTT' and t.table_name='EMP';OWNER &nb...【阅读全文】