Red Gate forums :: View topic - Partitioned index issue
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Partitioned index issue

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
bantonuk



Joined: 28 Nov 2013
Posts: 1

PostPosted: Thu Nov 28, 2013 1:51 am    Post subject: Partitioned index issue Reply with quote

Source database 11.2.0.3
OS Oracle Linux 5.x

actual index in the database is defined as

CREATE INDEX "MRD_BUCKET1"."TEST_HASH_BUCKET_IDX" ON "MRD_BUCKET1"."MRD_NAMES" ("HASH_BUCKET_VALUE", "LASTNAME_FIRST_LETTER", "ENTITY_SEQ")
PCTFREE 10 INITRANS 20 MAXTRANS 255 NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "MRD_BUCKET1_DATA" GLOBAL PARTITION BY RANGE ("HASH_BUCKET_VALUE")
(PARTITION "P_0" VALUES LESS THAN (1) TABLESPACE "MRD_BUCKET1_DATA_PART_01" ,
PARTITION "P_1" VALUES LESS THAN (2) TABLESPACE "MRD_BUCKET1_DATA_PART_02" ,
PARTITION "P_2" VALUES LESS THAN (3) TABLESPACE "MRD_BUCKET1_DATA_PART_03" ,
PARTITION "P_3" VALUES LESS THAN (4) TABLESPACE "MRD_BUCKET1_DATA_PART_04" ,
PARTITION "P_4" VALUES LESS THAN (5) TABLESPACE "MRD_BUCKET1_DATA_PART_05" ,
PARTITION "P_5" VALUES LESS THAN (6) TABLESPACE "MRD_BUCKET1_DATA_PART_06" ,
PARTITION "P_6" VALUES LESS THAN (7) TABLESPACE "MRD_BUCKET1_DATA_PART_07" ,
PARTITION "P_7" VALUES LESS THAN (Cool TABLESPACE "MRD_BUCKET1_DATA_PART_08" ,
PARTITION "P_8" VALUES LESS THAN (9) TABLESPACE "MRD_BUCKET1_DATA_PART_09" ,
PARTITION "P_ELSE" VALUES LESS THAN (MAXVALUE) TABLESPACE "MRD_BUCKET1_DATA_PART_10" );

but when i pull it out via the tool ...i get this

CREATE INDEX mrd_bucket1.test_hash_bucket_idx ON mrd_bucket1.mrd_names(hash_bucket_value,lastname_first_letter,entity_seq)
PARALLEL;

all the partition information is gone
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 90
Location: Red Gate Software

PostPosted: Mon Dec 02, 2013 11:13 am    Post subject: Reply with quote

Hi,

Thank you for getting in touch, it seems our support team have since also been in touch, but there is also a request on our public UserVoice forum for this, for anybody else who finds this thread:

https://redgate.uservoice.com/forums/174014-oracle-tools/suggestions/4427580-check-in-database-storage

Best regards,
Michael Christofides

Product Manager
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group