Thanks,
Wasim
On Tue, 16 Jul, 2024, 12:31 pm Kashif Zeeshan, <kashi.zeeshan@xxxxxxxxx> wrote:
FYIOn Tue, Jul 16, 2024 at 11:56 AM Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx> wrote:Hi WasimOn Fri, Jul 12, 2024 at 10:23 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:Hi KashifIs there a steps to create the the partition tables ?Yes, you can check the following linkI mean to say first create the tables and then insert the data lastly create index on them ?It's up to you which way you followYou can create the table and indexes first and insert data later and vice versa.What I did I created the table at once with all partition tables and indexes and then I inserted data by insert script. Is it ok?YesAnd I also created the indexes globally on the parent table the partition tables automatically took the indexes. Let me know what you think.Thanks,WasimOn Thu, 11 Jul, 2024, 1:54 pm Kashif Zeeshan, <kashi.zeeshan@xxxxxxxxx> wrote:HiWhen you create an index on Partition table then the index is created for all the Partitions so when you re-index then you need to re-index each partition separately.RegardsKashif ZeeshanOn Thu, Jul 11, 2024 at 1:16 PM Wasim Devale <wasimd60@xxxxxxxxx> wrote:Hi All,I have partitioned a table and levied indexes on it but when I do maintenance activities like reindexing it's not happening and the error is index not present on the partitioned table.Please highlight some points on it, Is I am missing something?Thanks,Wasim
