Jdi na obsah Jdi na menu
 

create partitions

3. 2. 2010




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řidat komentář

Přehled komentářů

levitra cost walmart fbdcacldAdvorBtjSmeaww

(Jbsdscabs, 23. 4. 2021 13:44)

Singulair https://onlinecanda21.com/ Chloromycetin

Odpovědět

when should i take cialis olgsanvoegfdAdvorBtjSmeawm

(GrvguefS, 27. 3. 2021 6:57)

https://kloviagrli.com/ - viagra original use https://vigedon.com/ - viagra erection https://llecialisjaw.com/ - buy cialis online overnight shipping https://jwcialislrt.com/ - goodrx cialis https://jecialisbn.com/ - cialis manufacturer

Odpovědět

« předchozí

1 | 2