OraFAQ Forum: SQL & PL/SQL » Convert into partition table

Home » SQL & PL/SQL » SQL & PL/SQL » Convert into partition table (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Convert into partition table [message #404714]

Sat, 23 May 2009 00:44

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

Report message to a moderator

Re: Convert into partition table [message #404727 is a reply to message #404714]

Sat, 23 May 2009 01:19

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Convert into partition table [message #404728 is a reply to message #404714]

Sat, 23 May 2009 01:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 16:17:03 CST 2024