【翻译自mos文章】为table 的partition 建立synonym
来源:互联网 发布:如何删除linux双系统 编辑:程序博客网 时间:2024/05/22 05:43
本文参考自:
How to Create a Synonym on a Table Partition (Doc ID 119805.1)
How to Create a Synonym on a Table Partition:=============================================You cannot directly create a synonym on a table partition by specifying the partition name and table name with the CREATE SYNONYM command. You have to create a view on the partition, and then create a synonym on the view. This is a two-step method instead of a single-step method.Follow the steps in this example to create the synonym: $ sqlplus scott/tiger SQL> create table emp_pt ( empno number primary key, ename varchar2(30)) partition by range (empno) ( partition p8000 values less than (8001), partition p9000 values less than (9001), partition p10000 values less than (10001), partition pothers values less than (99999999)); SQL> insert into emp_pt select empno, ename from emp; --- Populated the partition table EMP_PT with existing --- data from the EMP table. SQL> commit; SQL> select * from emp_pt; EMPNO ENAME ----- ----------------- 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN ... 9999 ANDY SQL> select * from emp_pt partition (p8000); EMPNO ENAME ----- --------------------- 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN ... 7934 MILLER SQL> create view emp_pt_p8000 as select * from emp_pt partition (p8000); SQL> desc emp_pt_p8000 Name Null? Type ----------------------------------- ------ ----------- EMPNO NUMBER ENAME VARCHAR2(30) SQL> create synonym p8000 for emp_pt_p8000; SQL> desc p8000 Name Null? Type ----------------------------------- ------ ----------- EMPNO NUMBER ENAME VARCHAR2(30) SQL> select * from p8000; EMPNO ENAME ----- ------------------------------ 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN ... 7934 MILLER SQL>
0 0
- 【翻译自mos文章】为table 的partition 建立synonym
- 【翻译自mos文章】在windows平台上怎么启用Oracle database 企业版的partition?
- 【翻译自mos文章】OGG Director 不会purge log table
- 【翻译自mos文章】怎么有效的drop 或者truncate 有大量extents的table?
- 【翻译自mos文章】控制OGG Director 中Repository Table 保留几天记录的参数
- 【翻译自mos文章】在12c中Create or Truncate Table时很慢,等待事件为 DFS Lock Handle wait
- 【翻译自mos文章】为DataGuard的 Redo Transport 启用加密
- [翻译自mos文章]提交的一个job 不运行
- 【翻译自mos文章】job 不能自动执行的解决方法
- 【翻译自mos文章】回收 asm磁盘空间的方法
- 【翻译自mos中文文章】重建控制文件的方法
- 【翻译自mos文章】参数Db_recovery_file_dest_size的最大值是多少
- 【翻译自mos文章】SGA_TARGET与SHMMAX的关系
- 【翻译自mos文章】Windows Service Oracleremexecservice 是干什么的
- 【翻译自mos文章】对rman 压缩的彻底理解
- 【翻译自mos文章】监控flashback database 的进度
- 【翻译自mos文章】rman 标准版和企业版的兼容性
- 【翻译自mos文章】Linux 操作系统下的内存使用
- Erlang学习笔记(4) -- 列表解析
- 灯塔(LightHouse)
- JavaScript常见类型转换函数
- Python之linecache模块
- 【计算几何】点在多边形内部
- 【翻译自mos文章】为table 的partition 建立synonym
- iOS多线程编程之NSThread的使用(★★★推荐,为原作者点赞★★★)
- 转:Android开发之onClick事件的三种写法
- 【codechef】Devu and his Class(巧妙的 模拟,分类讨论)
- LeetCode—Binary Tree Right Side View 二叉树层序遍历变形,Flatten Binary Tree to Linked List前序遍历变形
- 基于PredictionIO的推荐引擎打造,及大规模多标签分类探索
- CLR编写Insert Trigger
- 群
- android OnScrollListener 监听的简单应用