Partitioned tables / split clause
11/02/2019 11:47
I've been trying to create a partition at the end of a table & gotora-14074/ metalink advised I should use the split syntax but I can'tseem to get it to work Please find enclosed example SQL> ALTER TABLE DS_ORGANISATION SPLIT PARTITION START_DATE_2006 VALUESLESS THAN TO_DATE('01-01-2007', 'DD-MM-YYYY') TABLESPACE DSTPDATSML2; I am trying to add a partition ...does anyone have the rightsyntax/advisce? Thanks in advance for any help you can givecheersChris B PS Oracle is 9.2.0.5 EE

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
11/02/2019 11:47 - chris b <chris.brown@providenthims.co.uk> wrote in message news:1136996498.212939.291720@g49g2000cwa.googlegroups.com...

This looks about right.

You split AT a value, and INTO two other partitions.

ALTER TABLE DS_ORGANISATIONSPLIT PARTITION START_DATE_2006at TO_DATE('01-01-2007', 'DD-MM-YYYY')into ( partition start_date_2006 tablespace DSTPDATSML2, partition start_date_2007 tablespace DSTPDATSML3);

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
11/02/2019 11:47 - thanksChris B

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below