skip to main | skip to sidebar

Grind

Wednesday, April 4, 2007

add new partitions

Use the following to add new date partitions ...

alter table ... add partition ... values less than (to_date(...))
...
Posted by Sam at 4:09 PM
Labels: dba, partitions
Newer Post Older Post Home

Labels

  • architecture (2)
  • bug (1)
  • certification (1)
  • character set (2)
  • constaints (1)
  • database links (2)
  • dba (2)
  • ddl (1)
  • discoverer (1)
  • Discussion (3)
  • dml (1)
  • dynamic sql (1)
  • exceptions (1)
  • execute immediate (1)
  • faq (1)
  • flashback (2)
  • hardware (2)
  • hints (3)
  • keyboard (2)
  • locks (1)
  • mac (2)
  • materialized views (1)
  • partitions (3)
  • performace (3)
  • performance (1)
  • plsql (4)
  • recovery (2)
  • redo (1)
  • sizing (1)
  • SQL (8)
  • star (1)
  • storage (1)
  • table (1)
  • tables (1)
  • tablespaces (2)
  • temp tablespace (1)
  • transformation (1)
  • tuning (1)
  • UNDO (4)
  • unix (1)
  • upgrade (1)
  • waits (1)
  • wrapper (1)
  • xplan (2)

Blog Archive

  • ▼  2007 (41)
    • ►  September (3)
    • ►  August (7)
    • ►  June (3)
    • ►  May (3)
    • ▼  April (12)
      • Tracing ...
      • XPLAN PLAN
      • dynamic sql - dml
      • blocking sessions
      • savepoints
      • truncate partitions
      • add new partitions
      • outer joins
      • execute immediate exceptions
      • adding quotes in dynamic sql
      • hiding CODE
      • database upgrade
    • ►  March (13)

me

me