Home » SQL & PL/SQL » SQL & PL/SQL » Convert into partition table (Oracle 10g)
Convert into partition table [message #404714] Sat, 23 May 2009 00:44 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
The emp table contains following data

SQL> select * from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7698 BLAKE MANAGER 7839 01-MAY-81 4100 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7934 MILLER CLERK 7782 23-JAN-82 1300 10

I was tried to convert into partition table using the following code,but i got the error.
please help me.

Thanks in advance.


SQL> create table emp_partition
partition by range(deptno)
(partition p1 values less than(20),
partition p2 values less than(30),
partition p3 values less than(maxvalue))
as
select * from emp;

SQL> /
select * from emp
*
ERROR at line 6:
ORA-14400: inserted partition key does not map to any partition
Re: Convert into partition table [message #404727 is a reply to message #404714] Sat, 23 May 2009 01:19 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I'm not getting any error.
You have posted 70+ posts till now.
Please show some maturity in putting code tags and test case creation.
Which version you are working on?

By
Vamsi
Re: Convert into partition table [message #404728 is a reply to message #404714] Sat, 23 May 2009 01:25 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not able to post correctly.
Still not able to rear a message (what does "inserted partition key does not map to any partition" means for you?)
Still not able to find the meaning of an error in the documentation or one the many sites that explain it.
Still not able to Google.

Regards
Michel

[Updated on: Sat, 23 May 2009 01:27]

Report message to a moderator

Previous Topic: how to get the first row of record ?
Next Topic: TO know when the table is updated
Goto Forum:
  


Current Time: Wed Dec 07 18:17:08 CST 2016

Total time taken to generate the page: 0.15571 seconds