您好,欢迎光临! 请 |

Oracle splitting partitions简单小结

Oracle splitting partitions简单小结

            本文简单记录在Oracle 10g数据库上对范围分区表的Splitting Partitions测试过程和结论,并不涉及到Oracle数据库中分区技术的详细描述。 1 测试环境及平台: OS: [root@localhost ~]# uname -rm 2.6.18-164.el5 x86_64 [root@localhost ~]# Oracle: SQL> selec......

删除undo表空间遇到ORA-30013及ORA-0

删除undo表空间遇到ORA-30013及ORA-01548的解决思路

今天在一套RAC环境下删除、切换其中一个实例的undo表空间时,遭遇ORA-30013及ORA-01548的错误,下面记录过程及解决方法。 1 创建新的UNDO表空间UNDOTBS3,并将当前实例的UNDO切换到UNDOTBS3之后,删除旧的UNDOTBS1时,遇到下述错误: SQL> drop tablespace undotbs1 including contents and datafiles; drop tablespace undotbs1 incl......

oracle 10g SYSAUX tablespace

oracle 10g SYSAUX tablespace

        The SYSAUX(System Auxiliary) tablespace is a new feature of Oracle 10g database,before 10g release,there wasn't this tablespace.After you created your database via DBCA(Database Configuration Assistant) tool,the SYSAUX tablespace was created for you automatically.   ......

Managing Oracle Tablespaces and Data

Managing Oracle Tablespaces and Data Files

A collection of 19 FAQs on creating and managing tablespaces and data files. Clear answers are provided with tutorial exercises on creating and dropping tablespaces; listing available tablespaces; creating and dropping data files; setting tablespaces and data files offline; removing corrupted data files. Topics i......