create partitions
which ones are missing .......
set linesize 222
col OWNER for a30
col SEGMENT_NAME for a30
select distinct owner, segment_name,partition_name
from
(select owner,partition_name , segment_name , segment_type ,bytes/1024/1024
from dba_segments where (partition_name like '%2010%' or
partition_name like '%2009%')
and not (segment_type like '%INDEX%'))
order by 1,2,3
/
solution:
SQL> ALTER TABLE (owner).(table_name) ADD PARTITION "2010_01" VALUES LESS THAN (TO_DATE('01-02-2010','DD-MM-YYYY'));
Komentáře
Přehled komentářů
terazosin and cialis https://rcialisgl.com/ - paypal cialis tadalafil what can i take to enhance cialis
online pharmacy canada dgsolbvfdExcedsuczhj
(FlamsVed, 27. 5. 2021 15:37)where can i buy cialis 20mg https://krocialis.com/ - wholesale cialis vigra vs cialis
tnoegfdAdvorBtjSmeawo
(guefSAsd, 26. 5. 2021 16:30)generic cialis black 800 mg https://cialisjla.com/ - brand cialis online 5mg of cialis
oakdell pharmacy dgsolbvfdExcedspjjbk
(LbsoFlams, 24. 5. 2021 11:03)us pharmacy cialis https://ucialisdas.com/ generic cialis
no prescription needed pharmacy fdvaefbfbldAdvorBtjSmeawo
(Lebnscabs, 23. 5. 2021 16:58)online pharmacy without prescription https://xlnpharmacy.com/ Kamagra Oral Jelly
Tadapox frbdcacldAdvorBtjSmeawo
(Jebgscabs, 23. 5. 2021 13:05)canadian pharmacy online canada https://pharmacylo.com/ Pilex
pharmacy clipart dgsolbvfdExcedssydhb
(LbsoFlams, 18. 5. 2021 15:59)cialis without a rx https://ucialisdas.com/ aussie cialis
best canadian pharmacies fdvaefbfbldAdvorBtjSmeawe
(Lebnscabs, 18. 5. 2021 10:36)online drug store https://xlnpharmacy.com/ best online pharmacies canada
canadian pharmacies not requiring prescription frbdcacldAdvorBtjSmeaww
(Jebgscabs, 18. 5. 2021 7:49)canada drugs pharmacy https://pharmacylo.com/ Cialis Soft Tabs
mimaki family pharmacy dgsolbvfdExcedsrubvt
(LbsoFlams, 12. 5. 2021 16:44)where to buy cialis online https://ucialisdas.com/ side effects of cialis and grapefruits
generic cialis au afhsdbcExcedsyeotl
(RebfFlams, 12. 5. 2021 15:47)buy cialis pay pal https://rcialisgl.com/ generic vs brand name cialis
viagra for 25 year old fcsogsaxzvofbldAdvorBtjSmeawq
(Anooscabs, 5. 5. 2021 1:54)online rezepte fГјr viagra https://llviagra.com/ buy viagra in spain
help with writing a thesis fhsbbolthdAdvorBtjSmeawy
(Fbsfscabs, 3. 5. 2021 1:43)Cialis Super Active https://uspharmus.com/ mexican pharmacy online
help writing a thesis statement fcsgsaxzvofbldAdvorBtjSmeawd
(Abdgscabs, 2. 5. 2021 2:03)Brand Levitra https://canadianeve21.com/ - Levitra Oral Jelly Kamagra Oral Jelly
professional pharmacy dgsbvfdExcedszynmr
(LhdvFlams, 1. 5. 2021 9:40)cialis voucher https://asciled.com/ - cialis/generic cialis 20mg
viagra vs levitra vs cialis fbdcacldAdvorBtjSmeawq
(Jbsdscabs, 1. 5. 2021 0:46)canada pharmacy https://onlinecanda21.com/ online pharmacy viagra
phd by thesis only fhsbbolthdAdvorBtjSmeawt
(Fbsfscabs, 24. 4. 2021 22:09)pharmacy discount https://uspharmus.com/ - apollo pharmacy online Hyzaar
california pharmacy schools dgsbvfdExcedstjdqz
(LhdvFlams, 24. 4. 2021 16:34)cialis bestellen deutschland https://asciled.com/ - cialis20mg cialis
michigan board of pharmacy afhdbcExcedsybwra
(RfvbFlams, 24. 4. 2021 15:15)purchase cialis in canada https://cileve.com/ uninsured cost of cialis
levitra generic release date fdvefbfbldAdvorBtjSmeawe
(Lrbsscabs, 23. 4. 2021 17:15)how much levitra should i take https://uslevitraanna.com/ levitra online prescription
max cialis dose afhsdbcExcedsgfgmo
(Flamsloh, 28. 5. 2021 11:55)