Home > Default > Split Oracle 11g Table Partition and Insert new rows

Split Oracle 11g Table Partition and Insert new rows

November 30Hits:0
Advertisement
Hi,
I have a doubt that i would like to be clarified. I need to split a partition of a table with more than 800 Million records, but at the same time (during the split operation) i need to insert new records (not in the partition that is being splited). Is there any problem/risk doing this? Is the insert ETL process going to fail ?
Thanks in advance
Greetings.
Nuno
Edited by: user13512889 on 1/Set/2011 3:25

Answers

Hi Enrique,
Thanks for posting in MSDN.
Based on the description, you want to modify the formula for the A1 and B1 cell when you insert a new rows.
Yes, we can use Worksheet.Change to dermin the change of data on the worksheet then we can modify the formula as we wanted. Here is a sample for your reference:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Range("A1").Formula = "=MAX($A2:$A" & Me.UsedRange.Rows.Count & ")"
Me.Range("B1").Formula = "=MIN($B2:$B" & Me.UsedRange.Rows.Count & ")"
End Sub
You can more detail about Excel VBA developing from link below:
Getting Started with VBA in Excel 2010
Welcome to the Excel 2013 developer reference
Regards & Fei
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.

Read other 2 answers

Tags:

Related Articles

  • Split Oracle 11g Table Partition and Insert new rowsNovember 30

    Hi, I have a doubt that i would like to be clarified. I need to split a partition of a table with more than 800 Million records, but at the same time (during the split operation) i need to insert new records (not in the partition that is being splite

  • How to lock a table when i insert a rowNovember 30

    hi, friends, how to lock a table when i insert a row, then unlock the tableIf you want to lock the whole table so that no-one else can do DML then you go LOCK TABLE <table> IN EXCLUSIVE MODE. This lock remains in force until you commit or rollback.

  • How to find the size of a Oracle 11g tableOctober 11

    I want to find the size of a table in Oracle 11g. I hope, my question is clear. Please revert with the reply to my query. Regards--- List all tables sorted by size set lines 100 pages 999 col     segment_name     format a40 col      mb           form

  • Oracle 11g Table function returns no records on first callOctober 11

    Hello, On a Oracle 11g R2 I've a table function ( PIPELINED ) returning rows selected from a table. The first time the function is selected, in a session ( I've tried to disconnect and log in again ), it returns no rows. I've tried to log the call us

  • Oracle 11g table compression featureOctober 11

    Is anybody using Oracle 11g's compression feature in production? I read a whitepaper on this and also read some forums/threads on this topic and so far I haven't read anything negative yet, that doesn't meant that there isn't anything that could have

  • Table maint genertr inserting multiple rows with all fields editableNovember 30

    Hi I have created a ztable in se11 and maintained table maintenance generator SM30. Now i need to insert multiple rows into the table with all fields editable. How can i achieve this? Thanks in advance.> deepak thimmegowda wrote: > Hi > > I ha

  • Error in Import data in oracle 11g tableOctober 11

    I have a table with structure as SQL> desc PSACTIVIMG Name Null? Type ACTIVITYNAME NOT NULL VARCHAR2(30 CHAR) SEQNO NOT NULL NUMBER(38) PSIMAGEVER NOT NULL NUMBER(38) IMGSEG BLOB when the script try to insart data into this table ,after 5 row it fail

  • Oracle 11g interval partitioning - meaningfull partition-namesNovember 30

    Hello, On 11g, when creating interval partitions, the partitions get automatically created just fine. Very nice feature. But is it possible to supply meaningfull names to them? Now they get names SYS_nnn, but I would like to name them for instance SA

  • Oracle 11G - Table access problemOctober 11

    Hi, Iam new to Oracle...After creating a DataBase I created a connection and role has SYSDBA... And then I create a table....called Table1. And then I create a new USER and I Connect with same Databse SID but the role has DEFAULT for this new USER...

  • Unable to make updates/deletes using MS Access to Oracle 11g tableNovember 30

    Please help! We recently upgrade our Oracle db to 11gR2. Prior to that, I could make updates to the 9i database just fine, now (after resolving a tns names issue), I am able to connect using ODBC and the MS Access database and I can see data (ie. sel

Copyright (C) 2017 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.252 s.