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(...))
...
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